mail merge with query that has one to many relationships

[RLB]

I am trying to do a mail merge from an access query which has values in
several rows. (Three tables joined by billie id field- Cust Table, Base
Table and No of Con Table). To perform the mail merge I need one letter which
contains all rows for that billie id.
In summary, a Billie Id which has several contracts for each billie id and I
want one letter for each billie id listing all the contracts. Also, I want
the field No of Con to print only once in the letter as it sums the total
number of contracts that would be listed. Is this possible in a Mail Merge
or should I do this in a report in access?

 

[Pat Hartman\(MVP\)]

If you can make the report in Access, that will be easier. The only way I
have found to print multiple "records" in a single document is to use OLE
and write the automation code myself. Mail Merge is one record, one
document so not usable with a 1-many query.

 

[RLB]

Thank you for your reply. The reason I switched to try a mail merge is
because when I set this up as a two page report (letter), one of my letters
contained records that caused the report to spill over to a second page. Is
there a remedy for that?

 

[Pat Hartman\(MVP\)]

Access doesn't have a "fit to page" feature as Word and Excel do. You can
try reducing the space between the detail lines and you can try reducing the
font size. But, if there is more data than will fit on a single page,
you'll get a second page.

If you use a wizard to make the report, it probably put heading information
in the report header which only prints on the first page of the report. I
find that I prefer to move this information to the page header so that it
will print at the top of each page.