Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to merge into an Excel Main Document with Excel Data-How? | Excel Discussion (Misc queries) | |||
Merge Excel Docs | Excel Discussion (Misc queries) | |||
Mail Merge in Excel | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
why can't I open my Excel data in Excel, but I can as a merge sour | Excel Discussion (Misc queries) |