View Single Post
  #1   Report Post  
DD Holt
 
Posts: n/a
Default How do I get a field to self adjust in a mail merge?

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?