View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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