HELP! Send filtered reports results as email body

[66biscuits]

Apologies for this, their may well be solutions for my this on here already, but I'm quite new to both Access VBA programming (no training) and I've been tasked with achieving something that seems to require a fairly good of knowledge of both.

I need to send by email the individual group results of a report to each recipient on that report. The wish is for that email to have the report results in the email body, not as an attachment.

I have experience with SQL via a proprietary database design that our business runs on. I have a handle on that and I'm happy with how I will design the database. I'm at a testing/trial stage with access so far.

Basically I scrape our SQL database into csv then link the access table to that. No it's not possible to link the Access tables directly to the main database. I write the SQL that selectively does the scrape, so I have control over that. Becuase the scrape is one csv file, I have also created the access database as one table.

I have queries and reports that show the data I want to email. I have made the actual email as the top group in my report, from there I have more orders of group and sort.

In my experimenting I have been able to report the data by email address with page breaks, and had a little success in adapting some code, but not enough that it works. I have tried a form with a command button and an event procedure.

I really need help and anything would be appreciated. I have very little to go on and no training. I use Office 2003

 

[pbaldy]

This plus the link to the looping code should get you started:

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

If you want data in the body instead of an attachment, you'll probably need a second recordset that gets each person's data within the loop of people.