How do I email a report without a prompt

G

George Grote

I have a database scheduled which generates a report. I need to e-mail it
from the schedule. I have the
DoCmd.SendObject acSendReport, "Report",acFormatRTF,
"[email protected]", , , "Report", , False in a module, but
Outlook generates a security warning and asks for a yes or no answer. Is
there any way around this?
 
M

Mike C

You can use Express ClickYes. Type that in on msn search and you should be
able to find it. It's freeware.
 
Top