ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I merge addresses from one excel worksheet to another? (https://www.excelbanter.com/excel-worksheet-functions/101236-can-i-merge-addresses-one-excel-worksheet-another.html)

Jennifer

Can I merge addresses from one excel worksheet to another?
 
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

Can I merge addresses from one excel worksheet to another?
 
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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Tue, 25 Jul 2006 10:14:01 -0700, Jennifer
wrote:

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


All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com