Using Excel for mail merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top