Can I merge addresses from one excel worksheet to another?

J

Jennifer

I have a newsletter that is in columns in Excel and I'd like to mail merge
addresses from another worksheet to the newsletter. How do I do this?
 
G

Gord Dibben

Jennifer

Generally Word is used as the mailmerge app with Excel as the data source.

However, it can be done using Excel alone.

John Walkenbach has a workbook for downloading that contains examples.

http://www.j-walk.com/ss/excel/tips/tip92.htm

For help on Word mail merge using Excel or Access 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


Gord Dibben MS Excel MVP

I have a newsletter that is in columns in Excel and I'd like to mail merge
addresses from another worksheet to the newsletter. How do I do this?
Click to expand...

Gord Dibben MS Excel MVP
 
Top