Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 402
  • Last Modified:

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.
0
paulbradley
Asked:
paulbradley
1 Solution
 
gbirkemeierCommented:
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

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now