creating a form letter

[buratti]

I am trying to create a form letter to mail merge in Word, but this isn't just your standard form letter using data from a single table/query. I am trying to create a "as best described as" an open invoices letter. Meaning I want a letter to be addressed to the customer (merging customer name, etc.), but later in the letter have a list of all invoices for that customer. To my knowledge I know how to create queries showing this data, but each new invoice would technically be a new record, and according to Word, a new record would create the next letter.

My exact situation is as follows: I have a Recycling report/letter already created in Word with parts of it shown below. Merged fields I need are in color.


On 5/4/2010, we assumed ownership, possession, title, and control of the materials...

...
Summary of Materials Received:
Qty. Materials Received Service
2.29 Tons Plastic Recycled
0.33 Tons Wood Recycled
...

Fields in green would be from table1 and red from table2 (related to table1). I know how to accomplish this by creating the letter in a Access report, but if possible would rather keep the letter in Word due to Words capabilities of manipulating the letter better (ie. font, word wrap, tab spacing, etc.)
Any suggestions on how to do this?

 

[HiTechCoach]

If it were mine, I would use an Access report and skip using Word.

 

[Guus2005]

Access is Access and Word is Word. Yes you can manipulate tekst better using Word.
So here's what you can do.

You can store the invoice information in a single field named INVOICE like this:

INVOICE="2.29;Plastic|0.33;Wood"

Use split to create an array of invoices and use the array to display the records.

arrInvoice=Split(INVOICE, "|")

HTH