Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2005

Tip: Looking for answers? Try searching our database.

mail merge screws up one record, others okay

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike - 08 Dec 2005 18:15 GMT
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?
Doug Robbins - Word MVP - 08 Dec 2005 18:49 GMT
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.

Signature

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

> Hi,  (Win 2K, Off 2K)
>
[quoted text clipped - 31 lines]
>
> What gives?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.