Email reports in certain formats

[gls]

Hi

When i hit the command button to email a report, a small window appears asking what output would i like to use, Excel, RTF, Snapshot etc. I always want the report to output using snapshot, is there someway I can tell the button once clicked, I would like the output to be snapshot viewer to avoid the window poping up.

Thankyou

Garry

 

[boblarson]

This should do it for you:

DoCmd.OutputTo acOutputReport, "YourReportNameHere", acFormatSNP, "YourOutputFileAndPathHere"

 

[gls]

Output file

Thankyou, where would i put this code you sent. Also I want the report to load as an email attachment, to to a file location. Can you help.

 

[boblarson]

Sorry, I thought you were just trying to get the output. To email, you can use the SendObject command:

DoCmd.SendObject acSendReport, "YourReportName", acFormatSNP, "ToPerson@email.com", , , "The Subject Line", "message Text Here"

You would put this code in the click event of the command button. If you aren't sure how to get to the code window, see here:

http://www.btabdevelopment.com/main/QuickTutorials/Wheretoputcodeforevents/tabid/56/Default.aspx