Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Evan Evan is offline
external usenet poster
 
Posts: 17
Default Merge fields in Word pulling data from wrong Excel Columns. Help m

I've spent hours on this. It is driving me crazy. Any help would be
infinately, utterly, completely appreciated.

I am using mail merge with Office 2003 to print out customers order details.
I created a Word template with merge field codes that correspond to column
headings in an Excel file. When I do the merge, the merge field codes should
be populated with data from the corresponding Excel column. The problem is,
the data comes from seemingly random columns. To see what I mean, please
take a look at the following example.

First 3 of about 50 entries in Word:

Name: { MERGEFIELD "Last_Name" }
Item: { MERGEFIELD "Item" }
Fabric: { MERGEFIELD "Fabric" }

First 3 of about 50 headings in Excel:

Column A: Fabric
Column B: Collar
Column C: Cuff

Here is what it looks like after I merge:

Name: August 09
Item:
Fabric: Blue07

You can see Word is places data from the wrong columns in 2 of the 3 fields.
Why is this happening? How can I get the right data to appear in the right
fields?

Thank you so much for any help.
 
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
Data Merge - Excel Records to Word Table Columns NOT Rows eagleshout Mailmerge 1 May 14th 07 07:54 AM
The wrong data being pulled from Excel! sally t Mailmerge 1 February 18th 06 08:17 PM
How can I add data fields to a data source in Word Mail Merge? cd Mailmerge 2 November 7th 05 06:41 PM
Formatting fields in Word (using Excel as Mail Merge Data) - need. John Mailmerge 1 April 12th 05 12:24 PM
excel/word merge: why are some data fields partially truncated? brooke Mailmerge 1 April 2nd 05 01:38 PM


All times are GMT +1. The time now is 12:52 AM.

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

About Us

"It's about Microsoft Word"