emailing reports

[blake7]

Hi, is there a way of adding a button to a report or form so that when it is
pressed the report is sent staight to a blank email as a attachment ready for
sending, In our business we use Lotus notes as our default emailing program ?
Thanks

 

[Arvin Meyer [MVP]]

Yes, from a form button, the code is:

DoCmd.SendObject acReport, "ReportName", , "email address", , , "subject", ,
True

Using Lotus, I think you'll need to have VIM.DLL on your machine to make it
work.

 

[blake7]

Hi Thanks, I will give it a try, will the VIM.DLL file already be on my pc
seeing as we use it as our default email program ???. Will the command
button after adding the code, launch into Lotus Notes ??

 

[Arvin Meyer [MVP]]

It should vim.dll should be on your PC, if not, you will be able to download
it from the Lotus website.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Bruno Laurans]

"tghrghtyejrytytr


Le 28/03/08 20:50, dans #[email protected], « Arvin Meyer