Everyone knows that the quickest and easiest method for sending an e-mail in MS Access is to use the SendObject method

1. Ms Access Sendobject

DoCmd.SendObject acSendReport, acFormatPDF the default e-mail program's new message window is successfully launched with an attached PDF. All of this seems to work fine. Send Email in Access VBA using CDO, SendObject, OlMailItem There are mainly two methods of sending email in Access VBA. The first method is to use CDO Object, another is to use SendObject Method, I will explain each method in the below sections.

This is all find an dandy, but there is one flaw, it uses the name of your MS Access report: “rpt_SalesForecast” or “rpt_SalesByRegion” access as the attachment name. This simply is not acceptable for most purposes. We want to have a name that reflects better what the report is about: “Sales forecast 2012”, “Average Sale for Montreal in July”.

I recently was in a discussion and theDBguy was kind enough to share a little trick to do exactly this without requiring a whole lot of extra coding and automation. I thought I’d share it for everyone to benefit from. Below is the code in question:

Ms Access Sendobject

Ms Access Send Email with Report as Attachment. Using VBA code builder in MS Access, I have been able to write code that opens Outlook and send me an email with the click of a button. I am having problems with adding an attachment. Most code I have found adds files outside the MS Database as an attachment, I would like to add a report created in my database as an attachment.

Short, sweet and simple! Thank you theDBguy!