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/MailMe...AMailMerge.htm
http://www.mvps.org/word/FAQs/MailMe...DataSource.htm
Or you can use John Walkenbach's mailmerge code.
http://spreadsheetpage.com/index.php..._without_word/
Site looks a little messy............best to download the sample workbook.
Gord Dibben MS Excel MVP
On Sat, 29 Aug 2009 04:40:01 -0700, atiq8961
wrote:
Dear friends,
Can I use mail merge in excel