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?

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

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.

"DD Holt" DD wrote in message
...
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?