Insert comma into address block

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J K Bliss - 03 Sep 2004 20:51 GMT

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.

Reply to this Message

Paul Lautman - 03 Sep 2004 23:51 GMT

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

> The standard MS address block in the mail merge does not
> put a comma after the last name and before the suffix if
[quoted text clipped - 9 lines]
>
> Thanks for your help.

Reply to this Message

Peter Jamieson - 04 Sep 2004 09:05 GMT

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

Signature

Peter Jamieson

> The standard MS address block in the mail merge does not
> put a comma after the last name and before the suffix if
[quoted text clipped - 9 lines]
>
> Thanks for your help.

Reply to this Message

Rate this thread: