Solved

Sending email in MS Access with VBA

Posted on 2006-06-26
2
347 Views
Last Modified: 2012-12-15
Hey,

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

Cheers.
0
Comment
Question by:paulbradley
2 Comments
 
LVL 3

Accepted Solution

by:
Dimkov earned 250 total points
ID: 16990200
0
 
LVL 4

Expert Comment

by:gbirkemeier
ID: 16994802
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now