Sending email in MS Access with VBA


Anyone able to point me in the direction of a straight forward way of sending emails in MS Access using VBA?

Who is Participating?
From the VBA help file:

SendObject Method

The SendObject method carries out the SendObject action in Visual Basic. For more information on how the action and its arguments work, see the action topic.


DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]

Sample VBA code:

DoCmd.SendObject acReport, stDocName, "Sample Report", ";", , , "Email Subject", "Text for body of message", 0

Search for SendObject in VBA help

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.