Hi,
I have a set of reports that print from a macro without using the preview option. I was wondering if I could send the reports by e-mail instead of print them to a group of various people.
What macro should I use ?
Thanks
Mike
Hi,
I have a set of reports that print from a macro without using the preview option. I was wondering if I could send the reports by e-mail instead of print them to a group of various people.
What macro should I use ?
Thanks
Mike
I'm thinking SendObject.
Dear Mike,
You can modify your macro to send the report by e-mail ... check the following steps:
Open your macro in design view
In action select (SendObject)
In action argument you can select the object type, name, output format and other sending parameters (TO / CC / subject / message)
Also you can insert a commans button to send this report
Write the following in (on click)
DoCmd.SendObject acReport, "REPORT_NAME", "SnapshotFormat(*.snp)", "TO", "CC", "BCC", "SUBJECT", "MESSAGE", False, ""
Thanks
Ahmed