How do I get a field to self adjust in a mail merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DD Holt - 29 Dec 2004 18:07 GMT

We download our data that autopopulates into colums in an Excel Spreadsheet.
We then take that spreadsheet and mail merge this datasource into a Word
document. In Excel, one of the fields is adding extra spaces in the
spreadsheet and those spaces are merging into the letter.

example: "ABC Company, Inc. , we thank you..."

How do I get this field to self adjust in order to rid itself of the extra
spaces before the mail merge?

Reply to this Message

Charles Kenyon - 29 Dec 2004 18:30 GMT

I suspect that the easiest solution lies in cleaning up your Excel file or
the source.

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> We download our data that autopopulates into colums in an Excel
> Spreadsheet.
[quoted text clipped - 6 lines]
> How do I get this field to self adjust in order to rid itself of the extra
> spaces before the mail merge?

Reply to this Message