Sending email statement from Access / Excel with Word

[jahistx]

Hi

I am attempting to create a customer statement in word using an Access table as my data source (although Excel is also an option). Everything works ok, apart from one thing; Each record from my data source is displayed in word as a seperate page, and gets emailed (via Outlook)seperately.

I need to be able to place all records fro each customer on one merged page, so that the customer receives one email displaying all records relating to them, rather than 10 emails with one record in each!

I am sure this is not too complicated, but its got me scratching my head.

I am using Office 2002.

Can anyone help please?

 

[JoyInOK]

When choosing the type of document for your main document (template) in Word, choose "Catalog" (Office 9x) or "Directory" (Office 200x) instead of "Letter". The records will print one after the other on the same page. Don't forget to put a line return after your sample entry, or the records will print all run together.
If this is already set up as a merged letter, I *think* you may be able to change the document type without retyping everything.