G Gord Dibben Aug 29, 2009 #2 Not an option in Excel. You can use Word as the mailmerge tool and Excel as the data source. For help on that................ 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 Or you can use John Walkenbach's mailmerge code. http://spreadsheetpage.com/index.php/tip/mail_merge_without_word/ Site looks a little messy............best to download the sample workbook. Gord Dibben MS Excel MVP
Not an option in Excel. You can use Word as the mailmerge tool and Excel as the data source. For help on that................ 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 Or you can use John Walkenbach's mailmerge code. http://spreadsheetpage.com/index.php/tip/mail_merge_without_word/ Site looks a little messy............best to download the sample workbook. Gord Dibben MS Excel MVP
