Mail Merge and Excel Datasource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erika - 07 Nov 2006 20:26 GMT

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

Reply to this Message

Cindy M. - 23 Nov 2006 17:35 GMT

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 :-)

Reply to this Message