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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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