Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge screws up one record, others okay
Hi, (Win 2K, Off 2K)
I've got a mail merge using an Excel data source, and I've got an issue where all my records merge fine, except for one of them (the 5th record) - on this record, Word acts as if most of the merge fields' source doesn't have anything (i.e. is blank where that field should show up) and combines all those fields (plus some extras that aren't in the merge document) into one somewhere else in the documents. If that explanation doesn't make complete sense, then example: Company : MergeField1 Name: MergeField2 Phone Number: MergeField3 Department: MergeField4 and for the other records, it shows up like Company: XYZ Inc. Name: Bob Smith Phone Number: 800-555-1234 Department: Finance but for record 5 I get: Company: XYZ Inc. Jim Black 800-555-9999 Plant Manager Name: Phone Number: Department: Production And if I go to the spot where the merge field should be, and "Toggle Field Codes" then it shows me the field code. but when I toggle back or update field, it's blank. What gives? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge screws up one record, others okay
I'd be looking closely at the Excel spreadsheet. Are you sure that the data
for that record is actually in the individual cells or not just all in the first cell. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Mike" wrote in message ... Hi, (Win 2K, Off 2K) I've got a mail merge using an Excel data source, and I've got an issue where all my records merge fine, except for one of them (the 5th record) - on this record, Word acts as if most of the merge fields' source doesn't have anything (i.e. is blank where that field should show up) and combines all those fields (plus some extras that aren't in the merge document) into one somewhere else in the documents. If that explanation doesn't make complete sense, then example: Company : MergeField1 Name: MergeField2 Phone Number: MergeField3 Department: MergeField4 and for the other records, it shows up like Company: XYZ Inc. Name: Bob Smith Phone Number: 800-555-1234 Department: Finance but for record 5 I get: Company: XYZ Inc. Jim Black 800-555-9999 Plant Manager Name: Phone Number: Department: Production And if I go to the spot where the merge field should be, and "Toggle Field Codes" then it shows me the field code. but when I toggle back or update field, it's blank. What gives? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort mail merge by merge record number | Mailmerge | |||
Mail Merge - Next Record If Statement | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
How to choose your own record deliminators in mail merge? | Mailmerge |