Want to send report to email

[connieharper]

I have a customer who wants to be able to email certain reports from an Access97 database program. After previewing a report, they want to be able to click a button that will open their email program and then allow them to attach the report to the email for sending.

 

[Talismanic]

Here is one way you could do it:

DoCmd.SendObject acReport, "YourReportName", "RichTextFormat(*.rtf)", "Whoever@nowhere.com", , , "SubjectLine", , False

You can do this a lot of different ways. For instance, if you leave off the email address you will get a prompt. Look at the SendObject macro for a list of the possible arguments. In fact I made this by converting a macro into Visual Basic from the tool macro window.