Sending Reports Automatically

  • Thread starter Thread starter David A
  • Start date Start date
D

David A

Can some tell me how to send a report out thru Outlook
To different people listed on the report
My report is grouped by Person

can you automatically email each group

otherwords all records belonging to John Doe sent in
one Email . And records belonging to Mary Smith in another
mail.

I want to get away from cut and pasting into Outlook
or Excel

I hope I am being clear If not I apologize
 
I've got part of the solution. Go to Macro's and select send object. Fill in
the details . As to how you could automate it to send to each person I'm not
sure.
 
I am just a novice but I would populate a multi-select list box with
the names you wish to send the report to. Set up a sql string in code
to that will be the recordsource for the report. Populate the
report_Open (On Open) with the sql string.

Then cycle thru the listbox item selected to populate the sql string
and send the report with the docmd.sendobject acSendReport ......

if you need some example code let me know

jdb
 
Back
Top