Create report then have it send itself via Outlook to several recepiants

[Repent]

I want to create a report based on a query, then have that report
inserted into an email that opens up, already addressed, so the user
can look over the info then push the "send" button himself.

how can I do this?

Access is 2007
Outlook is 2003

thanks all;

chris

 

[Repent34]

test

 

[J_Goddard via AccessMonster.com]

Hi -

I have never used it, but check out the DoCmd.SendObject method - it appears
to do what you are looking for. It is probably easiest to use with a stored
query, i.e. one where the criteria are fixed or based on form values, but it
may also work with a report in preview (not tested)

Here is an actual example I used to check this out (all one line in my code)
using a command button:

DoCmd.SendObject acSendReport, "Editing Report for Batch", acFormatSNP,
"Gxxxxxx JR@CMP XXXX@Ottawa-Hull", , , "Test Message Subject", "Test Message
Text", True

MS Outlook displays the unsent E-mail message is shown with the report as an
attachment (it can't put it in the message body), and you can add whatever
you want before sending.

HTH

John