Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Not Picking All Up data
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Not Picking All Up data
There wre 4 columns to bbegin with: Employee first name, Employee last name,
Guest first name (if any) and Guest last name (if any) -- Janet A. "Janet A. Thompson" wrote: 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. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Not Picking All Up data
Yes, there is Next Record field on all of the labels except the first label.
-- Janet A. "Doug Robbins - Word MVP" wrote: 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. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Not Picking All Up data
I put all the names in two columns to make it easier to select them via the
database. I just wanted first name, last name on the label and that was no problem. It was the missing names that got me. -- Janet A. "Doug Robbins - Word MVP" wrote: 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. |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Not Picking All Up data
How about instead of a series of disjointed replies, you describe in detail
exactly the procedure that you have been following. -- 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 ... I put all the names in two columns to make it easier to select them via the database. I just wanted first name, last name on the label and that was no problem. It was the missing names that got me. -- Janet A. "Doug Robbins - Word MVP" wrote: 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge not picking up all records | Mailmerge | |||
How can I add data fields to a data source in Word Mail Merge? | Mailmerge | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge | |||
How do I move data Colums within the data source of a mail merge | Microsoft Word Help | |||
data in mail merge letter being cut off - data source field size? | Mailmerge |