Link to home
Start Free TrialLog in
Avatar of paulbradley
paulbradley

asked on

Sending email in MS Access with VBA

Hey,

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

Cheers.
ASKER CERTIFIED SOLUTION
Avatar of Dimkov
Dimkov

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gbirkemeier
gbirkemeier

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.

Syntax

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

Sample VBA code:

DoCmd.SendObject acReport, stDocName, "Sample Report", "me@domain.com; you@domain.com", , , "Email Subject", "Text for body of message", 0

Search for SendObject in VBA help