mail merge

[Candice]

I tried to complete a mail merge from an excel spreadsheet to a Word 2003
envelope. Each entry has a space before the first letter of the first word.
I can't seem to remove it with out going through each individual envelope
after completing the merge and deleting it.

 

[Peter Jamieson]

Are you using ADDRESSBLOCK?

If so, then for example, if you chose the Mr. Josh Q. Randall Jr. layout and
the title (Mr.) and "Nickname" (Josh) are either blank or not matched, the
layout will stil insert a space before the "Q.". IN essence, the layout
expects there to be either a title or a nickname. Incidentally, if there is
a title, no nickname, and a "middle name" you will get Mr. Q. Randall Jr.
(i.e. two spaces before the Q).

You can either try reinserting your ADDRESSBLOCK with a different layout
that matches your data better, or use individual merge fields instead - see
Graham Mayor's pages at
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
and
http://www.gmayor.com/formatting_word_fields.htm

Peter Jamieson

 

[Candice]

THANK YOU!! That solved the problem. My supervisor says to tell you we love
you haha! But thanks again for describing the reasoning behind it not just
telling me what to do. We understand why it was adding the space now.