Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2007 mail merge using Excel 2007 data
Hi Everyone. I'm new to Office 2007 and I can't figure out this problem. I
created an address database in Excel to use in a Word mail merge for mailing labels. After several attempts I finally got the data to merge (the normal DDE method didn't work as it said there was no data). There are only 19 labels in the merge. They only show in Preview using the very top left label field; I can scroll through all of the 19 records and they all appear in the same spot. If I print the mail merge only one label prints in that very same spot. I need ALL of the labels to be on the same document. What am I doing wrong? Once I succeed in having all of the labels on the same page is it possible to only select one, or speciifc, label(s) to print without deleting the rest on the sheet? Any help is greatly appreciated. This is a project at work where data is on a network drive if that helps. Thank you and I hope you all have a great weekend! |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2007 mail merge using Excel 2007 data
Hi Munchichic,
Your problem description suggests you didn't choose the 'labels' merge option. -- Cheers macropod [Microsoft MVP - Word] "Munchichic" wrote in message ... Hi Everyone. I'm new to Office 2007 and I can't figure out this problem. I created an address database in Excel to use in a Word mail merge for mailing labels. After several attempts I finally got the data to merge (the normal DDE method didn't work as it said there was no data). There are only 19 labels in the merge. They only show in Preview using the very top left label field; I can scroll through all of the 19 records and they all appear in the same spot. If I print the mail merge only one label prints in that very same spot. I need ALL of the labels to be on the same document. What am I doing wrong? Once I succeed in having all of the labels on the same page is it possible to only select one, or speciifc, label(s) to print without deleting the rest on the sheet? Any help is greatly appreciated. This is a project at work where data is on a network drive if that helps. Thank you and I hope you all have a great weekend! |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2007 mail merge using Excel 2007 data
Thanks for the reply. I'm sorry but I don't understand your suggestion. I'm
very new to Office 2007 and haven't used mail merges too much in the past. What exactly do I need to do? Thank you! "macropod" wrote: Hi Munchichic, Your problem description suggests you didn't choose the 'labels' merge option. -- Cheers macropod [Microsoft MVP - Word] "Munchichic" wrote in message ... Hi Everyone. I'm new to Office 2007 and I can't figure out this problem. I created an address database in Excel to use in a Word mail merge for mailing labels. After several attempts I finally got the data to merge (the normal DDE method didn't work as it said there was no data). There are only 19 labels in the merge. They only show in Preview using the very top left label field; I can scroll through all of the 19 records and they all appear in the same spot. If I print the mail merge only one label prints in that very same spot. I need ALL of the labels to be on the same document. What am I doing wrong? Once I succeed in having all of the labels on the same page is it possible to only select one, or speciifc, label(s) to print without deleting the rest on the sheet? Any help is greatly appreciated. This is a project at work where data is on a network drive if that helps. Thank you and I hope you all have a great weekend! |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2007 mail merge using Excel 2007 data
I'm sorry. I forgot to mention that the merge did appear in the label format
showing the gridlines and all. The label settings were correct but only Row 1, Column 1 was being used for each address label. 19 addresses = 19 pages of labels since only one label per sheet was being used. I don't understand what I did wrong. Thanks again! "Munchichic" wrote: Thanks for the reply. I'm sorry but I don't understand your suggestion. I'm very new to Office 2007 and haven't used mail merges too much in the past. What exactly do I need to do? Thank you! "macropod" wrote: Hi Munchichic, Your problem description suggests you didn't choose the 'labels' merge option. -- Cheers macropod [Microsoft MVP - Word] "Munchichic" wrote in message ... Hi Everyone. I'm new to Office 2007 and I can't figure out this problem. I created an address database in Excel to use in a Word mail merge for mailing labels. After several attempts I finally got the data to merge (the normal DDE method didn't work as it said there was no data). There are only 19 labels in the merge. They only show in Preview using the very top left label field; I can scroll through all of the 19 records and they all appear in the same spot. If I print the mail merge only one label prints in that very same spot. I need ALL of the labels to be on the same document. What am I doing wrong? Once I succeed in having all of the labels on the same page is it possible to only select one, or speciifc, label(s) to print without deleting the rest on the sheet? Any help is greatly appreciated. This is a project at work where data is on a network drive if that helps. Thank you and I hope you all have a great weekend! |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2007 mail merge using Excel 2007 data
It sounds as though you are merely previewing the merge rather than
coimpleting it - see http://www.gmayor.com/merge_labels_with_word_2007.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Munchichic wrote: I'm sorry. I forgot to mention that the merge did appear in the label format showing the gridlines and all. The label settings were correct but only Row 1, Column 1 was being used for each address label. 19 addresses = 19 pages of labels since only one label per sheet was being used. I don't understand what I did wrong. Thanks again! "Munchichic" wrote: Thanks for the reply. I'm sorry but I don't understand your suggestion. I'm very new to Office 2007 and haven't used mail merges too much in the past. What exactly do I need to do? Thank you! "macropod" wrote: Hi Munchichic, Your problem description suggests you didn't choose the 'labels' merge option. -- Cheers macropod [Microsoft MVP - Word] "Munchichic" wrote in message ... Hi Everyone. I'm new to Office 2007 and I can't figure out this problem. I created an address database in Excel to use in a Word mail merge for mailing labels. After several attempts I finally got the data to merge (the normal DDE method didn't work as it said there was no data). There are only 19 labels in the merge. They only show in Preview using the very top left label field; I can scroll through all of the 19 records and they all appear in the same spot. If I print the mail merge only one label prints in that very same spot. I need ALL of the labels to be on the same document. What am I doing wrong? Once I succeed in having all of the labels on the same page is it possible to only select one, or speciifc, label(s) to print without deleting the rest on the sheet? Any help is greatly appreciated. This is a project at work where data is on a network drive if that helps. Thank you and I hope you all have a great weekend! |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2007 mail merge using Excel 2007 data
In the mail merge main document, you need to use the Update Labels button
under the Write & Insert Fields section of the Mailings tab of the Ribbon to replicate the setup from the first label on the sheet to all of the other labels on the sheet. -- 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, originally posted via msnews.microsoft.com "Munchichic" wrote in message ... I'm sorry. I forgot to mention that the merge did appear in the label format showing the gridlines and all. The label settings were correct but only Row 1, Column 1 was being used for each address label. 19 addresses = 19 pages of labels since only one label per sheet was being used. I don't understand what I did wrong. Thanks again! "Munchichic" wrote: Thanks for the reply. I'm sorry but I don't understand your suggestion. I'm very new to Office 2007 and haven't used mail merges too much in the past. What exactly do I need to do? Thank you! "macropod" wrote: Hi Munchichic, Your problem description suggests you didn't choose the 'labels' merge option. -- Cheers macropod [Microsoft MVP - Word] "Munchichic" wrote in message ... Hi Everyone. I'm new to Office 2007 and I can't figure out this problem. I created an address database in Excel to use in a Word mail merge for mailing labels. After several attempts I finally got the data to merge (the normal DDE method didn't work as it said there was no data). There are only 19 labels in the merge. They only show in Preview using the very top left label field; I can scroll through all of the 19 records and they all appear in the same spot. If I print the mail merge only one label prints in that very same spot. I need ALL of the labels to be on the same document. What am I doing wrong? Once I succeed in having all of the labels on the same page is it possible to only select one, or speciifc, label(s) to print without deleting the rest on the sheet? Any help is greatly appreciated. This is a project at work where data is on a network drive if that helps. Thank you and I hope you all have a great weekend! |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2007 mail merge using Excel 2007 data
Thanks for the responses. I got the instructions for this mail merge directly
from this website. They make no mention of propagating anything. The final step was to select the finish and merge button and print the labels. Using the Update Field option I was finally able to see all of the labels on one sheet. So the last explanation I got from Doug Robbins was very helpful. My only question at this point is whether or not there is a way to only print one specific label from a mail merge, or if you're forced to printint out the entire listing. Thanks for the help with this! "Doug Robbins - Word MVP" wrote: In the mail merge main document, you need to use the Update Labels button under the Write & Insert Fields section of the Mailings tab of the Ribbon to replicate the setup from the first label on the sheet to all of the other labels on the sheet. -- 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, originally posted via msnews.microsoft.com "Munchichic" wrote in message ... I'm sorry. I forgot to mention that the merge did appear in the label format showing the gridlines and all. The label settings were correct but only Row 1, Column 1 was being used for each address label. 19 addresses = 19 pages of labels since only one label per sheet was being used. I don't understand what I did wrong. Thanks again! "Munchichic" wrote: Thanks for the reply. I'm sorry but I don't understand your suggestion. I'm very new to Office 2007 and haven't used mail merges too much in the past. What exactly do I need to do? Thank you! "macropod" wrote: Hi Munchichic, Your problem description suggests you didn't choose the 'labels' merge option. -- Cheers macropod [Microsoft MVP - Word] "Munchichic" wrote in message ... Hi Everyone. I'm new to Office 2007 and I can't figure out this problem. I created an address database in Excel to use in a Word mail merge for mailing labels. After several attempts I finally got the data to merge (the normal DDE method didn't work as it said there was no data). There are only 19 labels in the merge. They only show in Preview using the very top left label field; I can scroll through all of the 19 records and they all appear in the same spot. If I print the mail merge only one label prints in that very same spot. I need ALL of the labels to be on the same document. What am I doing wrong? Once I succeed in having all of the labels on the same page is it possible to only select one, or speciifc, label(s) to print without deleting the rest on the sheet? Any help is greatly appreciated. This is a project at work where data is on a network drive if that helps. Thank you and I hope you all have a great weekend! |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2007 mail merge using Excel 2007 data
This web site? This is a peer group help forum. The link I posted earlier
explains the complete process with pictures. For a single label, merge just the one record in question or merge a range of records to a new document and delete the labels contents you don't require. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Munchichic wrote: Thanks for the responses. I got the instructions for this mail merge directly from this website. They make no mention of propagating anything. The final step was to select the finish and merge button and print the labels. Using the Update Field option I was finally able to see all of the labels on one sheet. So the last explanation I got from Doug Robbins was very helpful. My only question at this point is whether or not there is a way to only print one specific label from a mail merge, or if you're forced to printint out the entire listing. Thanks for the help with this! "Doug Robbins - Word MVP" wrote: In the mail merge main document, you need to use the Update Labels button under the Write & Insert Fields section of the Mailings tab of the Ribbon to replicate the setup from the first label on the sheet to all of the other labels on the sheet. -- 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, originally posted via msnews.microsoft.com "Munchichic" wrote in message ... I'm sorry. I forgot to mention that the merge did appear in the label format showing the gridlines and all. The label settings were correct but only Row 1, Column 1 was being used for each address label. 19 addresses = 19 pages of labels since only one label per sheet was being used. I don't understand what I did wrong. Thanks again! "Munchichic" wrote: Thanks for the reply. I'm sorry but I don't understand your suggestion. I'm very new to Office 2007 and haven't used mail merges too much in the past. What exactly do I need to do? Thank you! "macropod" wrote: Hi Munchichic, Your problem description suggests you didn't choose the 'labels' merge option. -- Cheers macropod [Microsoft MVP - Word] "Munchichic" wrote in message ... Hi Everyone. I'm new to Office 2007 and I can't figure out this problem. I created an address database in Excel to use in a Word mail merge for mailing labels. After several attempts I finally got the data to merge (the normal DDE method didn't work as it said there was no data). There are only 19 labels in the merge. They only show in Preview using the very top left label field; I can scroll through all of the 19 records and they all appear in the same spot. If I print the mail merge only one label prints in that very same spot. I need ALL of the labels to be on the same document. What am I doing wrong? Once I succeed in having all of the labels on the same page is it possible to only select one, or speciifc, label(s) to print without deleting the rest on the sheet? Any help is greatly appreciated. This is a project at work where data is on a network drive if that helps. Thank you and I hope you all have a great weekend! |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2007 mail merge using Excel 2007 data
I didn't mean this specific location; I meant on the Microsoft website under
Help and How To. I even printed the instructions out and brought them to work which is why I was confused about the result I was getting. They literally say to click the Finish & Merge button and Print the labels as the "final step". And then it made no mention of using the Update Fields option to complete the formatting. When I need to print one label at a time it will be a different label each time. So doing another merge or changing the settings is more work than just deleting the rest of the page and printing what I need when needed. That or just printing the labels beforehand as a full sheet and only pulling the ones that are needed. Thanks again for the help. I'm surprised that the help I got here was more useful than the instructions that are on the Microsoft website for this process to begin with! "Graham Mayor" wrote: This web site? This is a peer group help forum. The link I posted earlier explains the complete process with pictures. For a single label, merge just the one record in question or merge a range of records to a new document and delete the labels contents you don't require. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#10
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2007 mail merge using Excel 2007 data
You must "update" or "propagate" the labels in the mail merge main document
BEFORE completing the merge. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Munchichic" wrote in message ... I didn't mean this specific location; I meant on the Microsoft website under Help and How To. I even printed the instructions out and brought them to work which is why I was confused about the result I was getting. They literally say to click the Finish & Merge button and Print the labels as the "final step". And then it made no mention of using the Update Fields option to complete the formatting. When I need to print one label at a time it will be a different label each time. So doing another merge or changing the settings is more work than just deleting the rest of the page and printing what I need when needed. That or just printing the labels beforehand as a full sheet and only pulling the ones that are needed. Thanks again for the help. I'm surprised that the help I got here was more useful than the instructions that are on the Microsoft website for this process to begin with! "Graham Mayor" wrote: This web site? This is a peer group help forum. The link I posted earlier explains the complete process with pictures. For a single label, merge just the one record in question or merge a range of records to a new document and delete the labels contents you don't require. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Excel 2007 cell data into word 2007 fields? | Microsoft Word Help | |||
Word 2007 Mail Merge Data | Mailmerge | |||
Mail Merge Labels (Word 2007) w/ Excel (2007) | Microsoft Word Help | |||
Mail Merge Labels (Word 2007) from Excel (2007) | Microsoft Word Help | |||
Word 2007 Mail Merge through Excel | Mailmerge |