Mail Merge in Excel

[AP200450]

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

 

[Peo Sjoblom]

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


Regards,

Peo Sjoblom

 

[PY & Associates]

We did it not long ago in the ng please

 

[protonLeah]

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.

 

[Art Farrell]

Hi,

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

http://search.atomz.com/search/?sp-q=merge&sp-a=000336ae-sp00000000

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

CHORDially,
Art Farrell