I know how to do mail merge in Word.
Does anybody know how to do a similar thing in Excel ?
That is, list a series of customer addresses, create a template with form
fields, then create multiple invoices by merging the database with the form
fiels in the template.
Many thanks,
AP200450

There is no such way, what you do is use Word with the source data from Excel


Regards,

Peo Sjoblom

"AP200450" wrote:

I know how to do mail merge in Word.
Does anybody know how to do a similar thing in Excel ?
That is, list a series of customer addresses, create a template with form
fields, then create multiple invoices by merging the database with the form
fiels in the template.
Many thanks,
AP200450

We did it not long ago in the ng please


"AP200450" wrote in message
...
I know how to do mail merge in Word.
Does anybody know how to do a similar thing in Excel ?
That is, list a series of customer addresses, create a template with form
fields, then create multiple invoices by merging the database with the
form
fiels in the template.
Many thanks,
AP200450

You may find it easier to create the form on an Excel sheet, then write
a looping macro to copy record elements from the list to cells on the
form then print the sheet before copying the next record.


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=543856

Hi,

John Walkenbach has a downloadable example on "MailMerge Without Word" on
the following site:

http://search.atomz.com/search/?sp-q...6ae-sp00000000

You should be able to adapt his example which is a letter merge to fit your
invoice requirements.

CHORDially,
Art Farrell


"AP200450" wrote in message
...
I know how to do mail merge in Word.
Does anybody know how to do a similar thing in Excel ?
That is, list a series of customer addresses, create a template with form
fields, then create multiple invoices by merging the database with the
form
fiels in the template.
Many thanks,
AP200450