Using Excel for mail merge

[Guest]

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

 

[Guest]

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

 

[Gord Dibben]

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/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Gord Dibben MS Excel MVP

On Mon, 17 Jul 2006 04:51:01 -0700, Nelly Doone <Nelly

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