Email Individual Access Reports

[Nae]

I have a database that contains a report grouped, with a page break between groups. Each group has an email address, as well as other record specific details. I need to email each page to the email address on the page. For example, my table lists customers and the items they purchased throughout the month, with a quatities and prices. The report is a statement to the customer with details. I want to send one statement to each customer, with just their specific details. There are approximately 200, so I need this to be a "push of a button". I'm not real familiar with codes, but any help would be greatly appreciated.

[June7]

I don't know any email method that will allow sending a specific page of report. I suggest opening report filtered to single group, send email, repeat for next group. This can be automated with VBA code looping through a recordset. The recordset would have a unique record for each group that can be read for the filter criteria in the WHERE CONDITION argument of DoCmd.OpenReport.

Email is common topic, search forum. Might find this one of interest: https://www.accessforums.net/showthr...ght=sendobject

[Ebroomer]

Nae, have you found a solution? I have the same problem.

[orange]

I think June7 has given you the most viable approach. Try her solution approach.