Access table mail merge problem

[Cordeiro82]

Hey All,

I am trying to create a product list in a single document instead of each product on multiple documents. My data source is a table called Email in the Database, that refreshes everytime a button to load the .dot file on the quotes form is pressed. My current table looks like this -

Quote_ID ProductDescription Quantity Price
2233 White Paper 3 Pallets 24/Case
2233 Green Paper 2 Pallets 25/Case

Right now each product is merging to a new document. I want to be able to save all the products to the same document as they are always under the same Quote_ID in the table. Any help would be greatly appreciated.

 

[dhookom]

This is a Word question and can be handled with NextIf

Field codes: NextIf field
{ NEXTIF Expression1 Operator Expression2 }

Compares two expressions. If the comparison is true, Microsoft Word merges the next data record into the current merge document. Merge fields that follow the NEXTIF field in the main document are replaced by values from the next data record rather than the current data record. If the comparison is false, Word merges the next data record into a new merge document.

Don't use the NEXTIF field in the current version of Word. You can select data records more easily by using the Mail Merge Recipients dialog box, which appears when you connect to a data source during a mail merge.

Note NEXTIF fields cannot be used in footnotes, endnotes, annotations, headers, footers, or data sources. The NEXTIF field cannot be nested within any field.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

You may consider a catalog mailmerge.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886