Mail Merge Report

[Tia]

I'm creating a Mail Merge Report to send info out to our customers about
their pricing. I've got the data in place and I'm including some fields that
I want to keep together. Right now, I've got teh following:

Dear Customer

We are sorry to announce that due to increasing fuel costs, we will need to
update our pricing. Please see below to see the products that you purchase
along with the new price.

Product Weight Price
218 25 0.25

We are sorry to announce that due to increasing fuel costs, we will need to
update our pricing. Please see below to see the products that you purchase
along with the new price.

Product Weight Price
230 40 0.36

What I would like is the following:
We are sorry to announce that due to increasing fuel costs, we will need to
update our pricing. Please see below to see the products that you purchase
along with the new price.

Product Weight Price
218 25 0.25
230 40 0.36

Any suggestions??? I don't want a letter for each product, but one letter
for each customers with all their products listed.

thanks for your time and help.

 

[Ken Sheridan]

I assume this is being done as an Access report rather than using the Access
data as the source for a Word mail merge. If so then group the report by
customer and give the group a group header and footer. Set the footer's
ForceNewPage property to 'After Section'. Put the customer's name and
address fields, the date, the body text of the letter and the headings for
the product columns in the group header, and the product details fields in
the detail section, which should be sized to one line's depth. Put 'Yours
sincerely' or whatever you are finishing the letter with in the group footer.

For an example see the Invoice report in the sample Northwind database which
comes with Access. You'll see that this produces one invoice per customer in
the same sort of format you want for your letter.

Ken Sheridan
Stafford, England