How do I trim input fields in Word 97 mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brett1958 - 15 Sep 2006 13:38 GMT

The input file for my mail merge is a CSV file from an ERP system, and each
field in the CSV is padded with trailing blanks to the ERP system field size.
Is it possible to automatically trim trailing blanks during mail merge?

Reply to this Message

Doug Robbins - Word MVP - 15 Sep 2006 18:25 GMT

No.

Maybe the best thing to do is to open the CSV file in Excel and use the
Trim() function in a formula on another sheet to create a replica of the
information without the padding and then use that sheet as the data source.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> The input file for my mail merge is a CSV file from an ERP system, and
> each
> field in the CSV is padded with trailing blanks to the ERP system field
> size.
> Is it possible to automatically trim trailing blanks during mail merge?

Reply to this Message