Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Erika Erika is offline
external usenet poster
 
Posts: 83
Default Mail Merge and Excel Datasource

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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default Mail Merge and Excel Datasource

Hi ?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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get Word 2003 to keep data file with mail merge main documen Yourcareercoach Mailmerge 9 August 10th 06 12:19 PM
Excel Data Source Changes not reflected in the Mail Merge Dave Baxandall Mailmerge 1 July 12th 06 10:45 PM
mail merge with excel datasource Deb H Mailmerge 1 February 15th 06 03:23 AM
Formatting using Excel datasource for mail merge Shawna Mailmerge 1 February 26th 05 12:19 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM


All times are GMT +1. The time now is 11:36 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"