Insert comma into address block

J

J K Bliss

The standard MS address block in the mail merge does not
put a comma after the last name and before the suffix if
the person has a suffix (Jr. etc)

Does anyone know how to edit the address block to include
a comma after the last name if there is a suffix? I have
toggled on the fields of the address block and have tried
hard coding a comma and it does not show up in the
preview. I also tried to use an If..Then..Else but it
did not show up in the preview. I know I'm missing
something but I cannot figure it out.

Thanks for your help.
 
P

Paul Lautman

1) Select the suffix field
2) Press Alt-F9 to show the field codes
3) Assuming that the field is called suffix, edit the field so that it says:
{ MERGEFIELD "suf" \b ,}
4) Alt-F9 again

Job done
 
P

Peter Jamieson

I don't think you will be able to do this in ADDRESSBLOCK
a. if you display the text of the ADDRESSBLOCK using Alt-F9 and put text
inside the << >>, in most cases it will display only if that field is
non-blank. However, Word seems to treat the first line of fields in the
ADDRESSBLOCK in a completely different way so that this approach does not
work
b. manual edits to ADDRESSBLOCK arte very easily lost and are not
recommended by MS

So you'll probably need to use individual MERGEFIELDs as suggested by Paul
Lautman
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top