Using Excel for mail merge
 

I have an invoice template in Excel. I want to set up a mail merge so that I
can include data on name, address etc. in the invoice. The merge data is
also in Excel. Is there a way to set up a mail merge in an excel document,
using an Excel data source, or do I need to do something else?

Thanks

Using Excel for mail merge
 

Mail Merge is a WORD feature which can use Excel as a data source. There is
no Excel equivalent although it is possible to invoke WORD from Excel.

HTH

"Nelly Doone" wrote:

I have an invoice template in Excel. I want to set up a mail merge so that I
can include data on name, address etc. in the invoice. The merge data is
also in Excel. Is there a way to set up a mail merge in an excel document,
using an Excel data source, or do I need to do something else?

Thanks

Using Excel for mail merge
 

Nelly

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

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 Mon, 17 Jul 2006 04:51:01 -0700, Nelly Doone <Nelly
wrote:

I have an invoice template in Excel. I want to set up a mail merge so that I
can include data on name, address etc. in the invoice. The merge data is
also in Excel. Is there a way to set up a mail merge in an excel document,
using an Excel data source, or do I need to do something else?

Thanks

Gord Dibben MS Excel MVP