Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Updating Word mailing labels from Excel data
Hello, helpful folks! I produce mailing labels in Word using Excel data
(wish it was easier, but I manage, with your help). When I revise the Excel data, I hoped it would transfer to the existing labels when I access the Word file. No such luck. I have to recreate the lables to get them updated. There must be a better way; this should work automatically but it doesn't for me. Suggestions? Thanks! |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Updating Word mailing labels from Excel data
If you save the mail merge main document as a separate file, then it's just
a matter of going in and using Merge to New Document (on the Mail Merge toolbar) to update the labels. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. DL; "Wisconsin" wrote in message ... Hello, helpful folks! I produce mailing labels in Word using Excel data (wish it was easier, but I manage, with your help). When I revise the Excel data, I hoped it would transfer to the existing labels when I access the Word file. No such luck. I have to recreate the lables to get them updated. There must be a better way; this should work automatically but it doesn't for me. Suggestions? Thanks! |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Updating Word mailing labels from Excel data
See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or
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 Suzanne S. Barnhill wrote: If you save the mail merge main document as a separate file, then it's just a matter of going in and using Merge to New Document (on the Mail Merge toolbar) to update the labels. DL; "Wisconsin" wrote in message ... Hello, helpful folks! I produce mailing labels in Word using Excel data (wish it was easier, but I manage, with your help). When I revise the Excel data, I hoped it would transfer to the existing labels when I access the Word file. No such luck. I have to recreate the lables to get them updated. There must be a better way; this should work automatically but it doesn't for me. Suggestions? Thanks! |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Updating Word mailing labels from Excel data
Suzanne, I believe I get it now, I wasn't sure what "mail merge main
document" means, but I think I do now. Graham, I frequently use your XP document, but I didn't see the answer there. I may be lost in the terminology. Thank you for the document! Thank you both for your kind assistance to a work-at-home person with nobody else to ask! Dale, Wisconsin "Graham Mayor" wrote: See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or 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 Suzanne S. Barnhill wrote: If you save the mail merge main document as a separate file, then it's just a matter of going in and using Merge to New Document (on the Mail Merge toolbar) to update the labels. DL; "Wisconsin" wrote in message ... Hello, helpful folks! I produce mailing labels in Word using Excel data (wish it was easier, but I manage, with your help). When I revise the Excel data, I hoped it would transfer to the existing labels when I access the Word file. No such luck. I have to recreate the lables to get them updated. There must be a better way; this should work automatically but it doesn't for me. Suggestions? Thanks! |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Updating Word mailing labels from Excel data
As I guess you've figured out, the "mail merge main document" is the basic
form you set up with form fields that link to your data source. Whenever you merge to a new document (or, if you're reckless, the printer), the result is based on the current content of the data source. More in these articles: How to create a Mail merge http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm Creating a mail merge Data Source http://word.mvps.org/FAQs/MailMerge/...DataSource.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. DL; "Wisconsin" wrote in message ... Suzanne, I believe I get it now, I wasn't sure what "mail merge main document" means, but I think I do now. Graham, I frequently use your XP document, but I didn't see the answer there. I may be lost in the terminology. Thank you for the document! Thank you both for your kind assistance to a work-at-home person with nobody else to ask! Dale, Wisconsin "Graham Mayor" wrote: See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or 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 Suzanne S. Barnhill wrote: If you save the mail merge main document as a separate file, then it's just a matter of going in and using Merge to New Document (on the Mail Merge toolbar) to update the labels. DL; "Wisconsin" wrote in message ... Hello, helpful folks! I produce mailing labels in Word using Excel data (wish it was easier, but I manage, with your help). When I revise the Excel data, I hoped it would transfer to the existing labels when I access the Word file. No such luck. I have to recreate the lables to get them updated. There must be a better way; this should work automatically but it doesn't for me. Suggestions? Thanks! |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Updating Word mailing labels from Excel data
Thanks again!
Dale "Suzanne S. Barnhill" wrote: As I guess you've figured out, the "mail merge main document" is the basic form you set up with form fields that link to your data source. Whenever you merge to a new document (or, if you're reckless, the printer), the result is based on the current content of the data source. More in these articles: How to create a Mail merge http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm Creating a mail merge Data Source http://word.mvps.org/FAQs/MailMerge/...DataSource.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. DL; "Wisconsin" wrote in message ... Suzanne, I believe I get it now, I wasn't sure what "mail merge main document" means, but I think I do now. Graham, I frequently use your XP document, but I didn't see the answer there. I may be lost in the terminology. Thank you for the document! Thank you both for your kind assistance to a work-at-home person with nobody else to ask! Dale, Wisconsin "Graham Mayor" wrote: See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or 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 Suzanne S. Barnhill wrote: If you save the mail merge main document as a separate file, then it's just a matter of going in and using Merge to New Document (on the Mail Merge toolbar) to update the labels. DL; "Wisconsin" wrote in message ... Hello, helpful folks! I produce mailing labels in Word using Excel data (wish it was easier, but I manage, with your help). When I revise the Excel data, I hoped it would transfer to the existing labels when I access the Word file. No such luck. I have to recreate the lables to get them updated. There must be a better way; this should work automatically but it doesn't for me. Suggestions? Thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailing Labels to Excel Question | Microsoft Word Help | |||
How come my mailing labels are not showing up from Excel???? | Microsoft Word Help | |||
mailing labels from Excel | Mailmerge | |||
Convert Mailing Labels to Word and Excel | Microsoft Word Help | |||
Can you print mailing labels from Excel? | Mailmerge |