Word Merge Question

[spyldbrat]

I am trying to word mail merge my query so I can automatically email my customers. I first tried creating a report but quickly learned reports don't communicate with the fields in word's mail merge. So, I created a Query which presents the data in word to be emailed...

The problem is that I have multiple lines for each customer in my query. The number of lines vary per customer. For each line, I have the email address associated with that customer. When I do the mail merge, it is creating a separate email each time the email address appears. So, instead of having 1 email with 10 lines of data, I have 10 emails with 1 line of data for the same customer. I tried to merge two separate tables (one with the multiple lines of data and one that just has the email address) but I couldn't get the mail merge to accept more than 1 query/table.



Is there another way to go about this?

[June7]

Why not email Access report?

[spyldbrat]

There are 2 reasons: 1) I would like to have the wording in the body of my email instead of an attachment 2) No one was able to tell me how to email the report to multiple customers via Access

[rpeare]

Access can do 1 and 2. Perhaps you can supply a sample version of your database with enough data to show a few variations in your email verbiage that'd be more constructive in helping you. Whether you want to have a single email going to several customers with the same attachment, or a separate email to each customer each having the same report, or a separate email to each customer with a different report, all of these are possible.

[June7]

There are numerous discussions showing both.

1. build email body from recordset of data - an alternative is to export report to HTML file and pull HTML file into email HTMLBody

2. loop through recordset to build multi-address string

The following seems to show it all:

https://www.accessforums.net/showthread.php?t=76869