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

[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

 

[Doug Robbins - Word MVP]

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

 

[Bill Davy]

Hi,
Yes, there is a <<Next Record>> field at the end of the text frame.
Rgds,
Bill

 

[Doug Robbins - Word MVP]

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

 

[Bill Davy]

I will try that this evening. I did not notice if alternate records were
omitted, which might make sense.
Rgds,
Bill

 

[Bill Davy]

That is the right asnwer.
Did MS change the way things work? Not that it matters, as long as I know.
Rgds,
Bill

 

[Doug Robbins - Word MVP]

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