Mail Merge and Excel Datasource

[Erika]

My datasource in excel lists product codes, the product codes begin with 2
spaces - then the number - space - letter. Example _ _271_A where the _
represents a blank space.

When I perform the mail merge I lose the beginning 2 spaces. How can I keep
those?

Erika

 

[Cindy M.]

Hi =?Utf-8?B?RXJpa2E=?=,

My datasource in excel lists product codes, the product codes begin with 2
spaces - then the number - space - letter. Example _ _271_A where the _
represents a blank space.

When I perform the mail merge I lose the beginning 2 spaces. How can I keep
those?

That's going to be very difficult, if not impossible. By default, Word trims
leading and trailing spaces. You can try copying the Excel table to a Word
document. Save that, then use it as the data source. Does that retain the
spaces?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail