Mail Merge formatting problems

Discussion:

(too old to reply)

2006-02-21 23:38:28 UTC

I'm using Excel and Word 2002 and have used mail merge quite a bit. Having a
problem today - whenever I merge my document the merged information shows up
in a different font and is bolded and larger than the rest of the text. I've
tried highlighting and changing font and nothing happens.

Any ideas?

--
KP

Doug Robbins - Word MVP

2006-02-22 05:50:26 UTC

Permalink

Use Alt+F9 to toggle on the field codes and add a \* charformat switch
inside the } and the apply the desired formatting to the M of MERGEFIELD.
Then, toggle off the display of the field codes and execute the merge.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Post by KP
I'm using Excel and Word 2002 and have used mail merge quite a bit. Having a
problem today - whenever I merge my document the merged information shows up
in a different font and is bolded and larger than the rest of the text. I've
tried highlighting and changing font and nothing happens.
Any ideas?
--
KP

2006-02-22 14:13:27 UTC

Permalink

Hi Doug,

I must be doing this wrong because I got an error message which says "Error!
Switch argument not specified."

Here is what my field code looks like: { MERGEFIELD "Amount" \* }. If I
understand your directions correctly, I also highlighted the M in Mergefield
and clicked on Format, Font and selected Bookman Old Style, Normal, Size 11.

Sorry for the confusion. This is a new problem for me and I'm not used to
working with the field codes.

Thanks.
--
KP

Post by Doug Robbins - Word MVP
Use Alt+F9 to toggle on the field codes and add a \* charformat switch
inside the } and the apply the desired formatting to the M of MERGEFIELD.
Then, toggle off the display of the field codes and execute the merge.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP

Graham Mayor

2006-02-22 15:30:57 UTC

Permalink

It should read { MERGEFIELD "Amount" \* Charformat}

and not { MERGEFIELD "Amount" \* }
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Post by KP
Hi Doug,
I must be doing this wrong because I got an error message which says
"Error! Switch argument not specified."
Here is what my field code looks like: { MERGEFIELD "Amount" \* }. If
I understand your directions correctly, I also highlighted the M in
Mergefield and clicked on Format, Font and selected Bookman Old
Style, Normal, Size 11.
Sorry for the confusion. This is a new problem for me and I'm not
used to working with the field codes.
Thanks.

Post by Doug Robbins - Word MVP
Use Alt+F9 to toggle on the field codes and add a \* charformat
switch inside the } and the apply the desired formatting to the M of
MERGEFIELD. Then, toggle off the display of the field codes and
execute the merge.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP

2006-02-22 16:34:20 UTC

Permalink

That did the trick. Thanks Graham!
--
KP

Post by Graham Mayor
It should read { MERGEFIELD "Amount" \* Charformat}
and not { MERGEFIELD "Amount" \* }
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Post by Doug Robbins - Word MVP
Use Alt+F9 to toggle on the field codes and add a \* charformat
switch inside the } and the apply the desired formatting to the M of
MERGEFIELD. Then, toggle off the display of the field codes and
execute the merge.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP