Reply to thread

Message: [QUOTE="MikeC, post: 4879410"] Sorry, my fault. When I ran my test, I made an oversight and then added to it by renaming one variable instance out of two, but I think you already figured that part out for yourself. The oversight was that I excluded one of the commas from the sendobject statement. The code runs, but patiently waits for the user to click the Send button in Outlook. ;-) Try this instead: Dim strReportName As String strReportName = "rptLeverage" DoCmd.SendObject acSendReport, strReportName, acFormatSNP, "[email]someone@somewhere.com[/email]", , _ , "It's A Snapshot File!!!", , False Also, Outlook 2003 has a security prompt that will force the user to click "Yes" in order to allow Access to send email. If this presents a problem for you, then I know of two solutions. Just let me know if you need help with this part. [/QUOTE]