Send object to email

[Guest]

Hi

I am trying to send a report to outlook.
Here is the code I've entered but it will not work?? PLease help

DoCmd.SendObject acSendReport, "Rpt name", "SnapshotFormat(*.snp), ,
"(e-mail address removed)", , "Title of email", "Message", False

What am I doing wrong, I keep getting the message

"The expression onclose you entered as the vent property setting produved
the following error: Syntax error.
*The expression may not result in the name of a macro, the name of a user
defined function or [Event Procedures]
* There may have been an error evaluating the function,event or macro"

Any help would be great
Thanks

 

[Steve Schapel]

Jefferson,

You have omitted the " at the end of the format argument. Try like this...
DoCmd.SendObject acSendReport, "Rpt name", "SnapshotFormat(*.snp)", ,
"(e-mail address removed)", , "Title of email", "Message", False