Can I merge addresses from one excel worksheet to another?

[Guest]

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?

 

[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?

Gord Dibben MS Excel MVP