L Louis & Nanci Mart Oct 24, 2005 #1 I have a list of names and addresses in an excel work sheet. How can I generate a label list for a mailing from it? Louis
I have a list of names and addresses in an excel work sheet. How can I generate a label list for a mailing from it? Louis
G Gord Dibben Oct 24, 2005 #2 Louis Labels from within Excel alone is a trial and error operation. Best to use Word for the mailmerge operation. For help on Word mail merge using Excel as the data source. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm And a training tutorial for creating envelopes and labels. http://office.microsoft.com/training/training.aspx?AssetID=RC010390291033 Gord Dibben Excel MVP
Louis Labels from within Excel alone is a trial and error operation. Best to use Word for the mailmerge operation. For help on Word mail merge using Excel as the data source. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm And a training tutorial for creating envelopes and labels. http://office.microsoft.com/training/training.aspx?AssetID=RC010390291033 Gord Dibben Excel MVP