Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.newusers
Bill Davy[_2_] Bill Davy[_2_] is offline
external usenet poster
 
Posts: 12
Default Word 2003 SP2: Missing records in mail-merge from Excel to directory

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


  #2   Report Post  
Posted to microsoft.public.word.newusers
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word 2003 SP2: Missing records in mail-merge from Excel to directory

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" wrote in message
...
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




  #3   Report Post  
Posted to microsoft.public.word.newusers
Bill Davy[_2_] Bill Davy[_2_] is offline
external usenet poster
 
Posts: 12
Default Word 2003 SP2: Missing records in mail-merge from Excel to directory

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

"Doug Robbins - Word MVP" wrote in message
...
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" wrote in message
...
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







  #4   Report Post  
Posted to microsoft.public.word.newusers
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word 2003 SP2: Missing records in mail-merge from Excel to directory

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" wrote in message
...
Hi,
Yes, there is a Next Record field at the end of the text frame.
Rgds,
Bill

"Doug Robbins - Word MVP" wrote in message
...
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" wrote in message
...
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









  #5   Report Post  
Posted to microsoft.public.word.newusers
Bill Davy[_2_] Bill Davy[_2_] is offline
external usenet poster
 
Posts: 12
Default Word 2003 SP2: Missing records in mail-merge from Excel to directory

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

"Doug Robbins - Word MVP" wrote in message
...
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" wrote in message
...
Hi,
Yes, there is a Next Record field at the end of the text frame.
Rgds,
Bill

"Doug Robbins - Word MVP" wrote in message
...
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" wrote in message
...
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














  #6   Report Post  
Posted to microsoft.public.word.newusers
Bill Davy[_2_] Bill Davy[_2_] is offline
external usenet poster
 
Posts: 12
Default Word 2003 SP2: Missing records in mail-merge from Excel to directory

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

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

"Doug Robbins - Word MVP" wrote in message
...
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" wrote in message
...
Hi,
Yes, there is a Next Record field at the end of the text frame.
Rgds,
Bill

"Doug Robbins - Word MVP" wrote in message
...
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" wrote in message
...
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















  #7   Report Post  
Posted to microsoft.public.word.newusers
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word 2003 SP2: Missing records in mail-merge from Excel to directory

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

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

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

"Doug Robbins - Word MVP" wrote in message
...
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" wrote in message
...
Hi,
Yes, there is a Next Record field at the end of the text frame.
Rgds,
Bill

"Doug Robbins - Word MVP" wrote in message
...
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" wrote in message
...
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

















Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge missing records Hogan Mailmerge 6 July 20th 07 03:36 PM
mail merge missing records marti Mailmerge 1 June 7th 07 10:02 AM
Missing Records in Word Mail Merge ducklaker Microsoft Word Help 5 April 16th 07 12:34 AM
How do I keep records together in a directory with mail merge? Priscilla Mailmerge 1 July 30th 05 05:29 AM
missing records in mail merge documents PaulaJenkins Mailmerge 1 February 2nd 05 11:50 PM


All times are GMT +1. The time now is 01:46 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"