Email Report to person assigned

[caniread]

I have an idea report that lists all open ideas and who is assigned to complete them. I want to automate a email delivery of the report to each individual person that is assigned to the ideas. The report would include only the ideas that are assigned to them and leave out the rest. I can do it right now by selecting the name before the report is run and then emailing that report to the person manually. Is there a way to accomplish this? I have a table that has all the names and I can also add each persons email address to it. Let me know if you need any further explanation.

[ranman256]

I have a form,
a list box of reports,
and a list box of people. (email is here)

I select the report, and the person, click send button
DoCmd.SendObject acSendReport, lstRpts, acFormatPDF, lstEmail, , , "Subject", "message"

[caniread]

Thank you for the reply. I only have one report to send but the report should only show what that person is assigned to. I want to have Access see if that person has a open idea and if so make a report for that person and email it. It should go through the name list for every person and send them their report if they have an open idea. I would like to have a button that I click on to get the process started. Will probably have to be done in VBA but I don't have a good understanding of it to write out the code.

[NTC]

This question comes up a lot. It might be a feature that Microsoft should add into the product - although they may not want to encourage what could be abused as a spam maker. In any case; no - there is no embedded method for what you seek.

what you do manually works - and so this is a case where you would have to craft some looping code to repeat the steps of making a single user report, sending it, closing it, making a new single user report, sending it, closing it, etc etc. and looping thru your list of persons. it is do-able.