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

"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

[PY & Associates]

We did it not long ago in the ng please


"AP200450" <[email protected]> wrote in message
news:[email protected]...
> 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

[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...6ae-sp00000000

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

CHORDially,
Art Farrell


"AP200450" <[email protected]> wrote in message
news:[email protected]...
> 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