A Allan Lamont Dec 15, 2003 #1 Want to print on address label sheet or envelopes. Already have spreadsheet ( data base) printed on excel 97.
Want to print on address label sheet or envelopes. Already have spreadsheet ( data base) printed on excel 97.
T Trevor Shuttleworth Dec 15, 2003 #2 Allan use mail merge in Word with your Excel spreadsheet as the source data. Very straight forward, particularly if you have standard labels. Regards Trevor
Allan use mail merge in Word with your Excel spreadsheet as the source data. Very straight forward, particularly if you have standard labels. Regards Trevor
G Gord Dibben Dec 16, 2003 #3 Allan Not too easily done in Excel without a lot of manipulation of data and row/column sizes. Best way is to use Word Mailmerge>Labels and Envelopes with Excel as data source. Some sites with info and help....... http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm http://www.mvps.org/dmcritchie/excel/mailmerg.htm Gord Dibben XL2002
Allan Not too easily done in Excel without a lot of manipulation of data and row/column sizes. Best way is to use Word Mailmerge>Labels and Envelopes with Excel as data source. Some sites with info and help....... http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm http://www.mvps.org/dmcritchie/excel/mailmerg.htm Gord Dibben XL2002
