Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
Data Merge - Excel Records to Word Table Columns NOT Rows | Mailmerge | |||
The wrong data being pulled from Excel! | Mailmerge | |||
How can I add data fields to a data source in Word Mail Merge? | Mailmerge | |||
Formatting fields in Word (using Excel as Mail Merge Data) - need. | Mailmerge | |||
excel/word merge: why are some data fields partially truncated? | Mailmerge |