Word 2003 SP2: Missing records in mail-merge from Excel to directory

  • Thread starter Thread starter Bill Davy
  • Start date Start date
B

Bill Davy

I keep my address book in Excel. The column headers are my own (see below).
There are extra columns like Sort Key (so I can sort the address book). To
print out a copy, I make a new document as a directory, with multiple
columns and each entry in a text frame. I select all entries. But some
entries do not appear in the output. Any idea why?
Rgds,
Bill

Headings:
Sort Key

Name

Children

Address1

Address2

City

State

PostalCode

Country

HomePhone

WorkPhone

MobilePhone

FaxPhone

Email
 
How do you have the mail merge main document set up? Specifically, do you
have any <<Next Record>> fields in it?

--
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,
Yes, there is a <<Next Record>> field at the end of the text frame.
Rgds,
Bill
 
It probably should not be there. Definitely it should not be there if you
are using a catalog or directory type mail merge main document.

--
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
 
I will try that this evening. I did not notice if alternate records were
omitted, which might make sense.
Rgds,
Bill
 
That is the right asnwer.
Did MS change the way things work? Not that it matters, as long as I know.
Rgds,
Bill
 
No, there have been no changes in this area of the software.

--
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
 
Back
Top