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

D

DD Holt

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?
 
C

Charles Kenyon

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

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