View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge Not Picking All Up data

I do not really understand what you mean by taking "the 3rd and 4th column
names .... and inserted them into the 1st and 2nd columns."

Can you advise the names of the fields in the Excel worksheet and how you
want the data from those fields arranged on the labels.

Where do you have Next Record fields on the labels in the main document
setup? There should be one and one only, before the first merge field in
all of the labels EXCEPT for the first label on the sheet?

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

See the article "Mail Merge with Word 2007" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/merge_labels_with_word_2007.htm


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

"Janet A. Thompson" wrote in message
...
In using a template someone gave me, I noticed that not all the Excel data
was being included in the Word merge. The Excel data's first column was
the
first names of employees and this column seemed to be a hyperlink to their
RSVP Outlook message. (Apparently, in Outlook you can set it up so that
responses come into an Excel database automatically.) I took the 3rd and
4th
column names (guests) (their names were not hyperlinked) and inserted
them
into the 1st and 2nd columns.

Why were some names not included. I ended up having to manually check off
each outputted tent card.

Baffling

On a second Excel database, I copy/pasted it to a Word table, then
manipulated the second column of names so that they were in the first
column.
Then performed the merge to a label and, again, I noticed not all were
being
picked up.

What was I doing wrong?
--
Janet A.