Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Microsoft Access Email Seminar
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   7 years ago

The Microsoft Access Email Seminar will teach you just about everything there is to know about sending and receiving email using Microsoft Access - with or without Microsoft Outlook. This seminar is for the intermediate to advanced Access developer. Topics include:

  • Microsoft Access Email SeminarSend Email Using Outlook
  • Export Access Reports as PDFs
  • Attach Files to Outgoing Email
  • Disable Outlook Security Warnings
  • Mail Merge Using Access and Word
  • Create Rich Text or HTML Email
  • Include Images in Emails
  • Broadcast Bulk Email Batches
  • Send Email Without Outlook
  • Connect Directly to a Mail Server
  • Create an Email from a Web Page
  • Embed Custom Mail Merge Fields
  • Add a Send Delay to Large Batches
  • Build Regular Email Templates
  • Assign Customers to Mailing Lists
  • Construct a Mail Server Database
  • Acquire Data from Incoming Emails
  • Build a Web Form to Collect Survey Data
  • Extract Files from Access Attachments
  • Track Email Deliverability
  • Email to SMS (Text Message) Gateways
  • Extract Attachments from Incoming Mail Click

Click here for more information on the Microsoft Access Email Seminar, including a complete course outline, sample video, sample database file, and lots more.

NEW! See my updated video for sending Email using Access and Outlook: Send Outlook Email


Private sub Upload Images   Link 
4 years ago
I put this code in a private sub and it does not work when i click the button

Private Sub Commande0_Click()
MsgBox "allo le monde"
End Sub

and this code either does not work

What is wrong ?

Reply from Alex Hedley:

How did you create the button event?
If you open the Form in Design View, click on the button and open the Properties Sheet, is there an event in the Click?
You need to link the button to the code, it may not be.
If you but a breakpoint in the sub does it hit?
Add a Reply
Email Seminar Upload Images   Link 
James Comninellis 
4 years ago
I have a specific VBA question. This is all good content but it's almost more than I need. I want to place a button in a form that will take all the emails in a query and place them in the "To" or "Bcc" field of an email. I have been working with the following code but with no success yet: Read More...
Add a Reply
Mass Email Upload Images   Link 
Derek Bowens 
4 years ago

Do you go through sending a mass email without attachments? I have a database that contains 400 emails and I would like to be able to send a BCC email to all active addresses. I am unable to perform this function through the macro or code builder option. Can you advise? Read More...
Add a Reply
Upload Images   Link 
Chris Thompson 
5 years ago
FYI, 2010 Outlook has the same Programmatic Access Security as 2013 Outlook used in your video. The available options are identical.
Add a Reply
Upload Images   Link 
James Gray 
5 years ago
It looks like the statement for adding attachments in now Msg.AddAttachment filename instead of Msg.Attachment.Add filename.  Maybe a change in CDO language in new Office 365?
Add a Reply
Upload Images   Link 
James Gray 
5 years ago
Just a quick note: I was having trouble getting the "minimum code" to function properly.  I was getting a "transport not connecting to server....error.  I googled the error and finally came up with a line of code to add to the minimum and it seems to eliminate the error.  That line of code is:msg.Configuration.Fields.Item("") = True.  Everything now seems to work just fine.  I am using Office 365 and Windows 10.  Thanks.
Add a Reply
Mailto Upload Images   Link 
Arnel Arnaldo 
5 years ago
Hi Richard,
Using the macro to set the values for EMailDatabaseObject parameter To to [Forms]![]![], the To on the message field appears as #mailto:#. Read More...
Add a Reply
Outlook 2016 seems to add mailto Upload Images   Link 
James Gray 
5 years ago
Outlook 2016 seems to add "mailto:" to all hyperlinks.  In my code, when it looks up the specific email address to send objects to, the email address turns into the original email from the database#mailto:email address from the database#.  Outlook then errs out, not understanding that to: email address.  I am unable to edit this mailto: out of the address in the editor.  Interestingly, any email address I entered using older versions of access seem to work...Any clues as to how to fix this? Read More...
Add a Reply
Video not found or access denied Upload Images   Link 
Arnel Arnaldo 
5 years ago
Video not found or access denied: url

Reply from Alex Hedley:

Can you try logging out and logging back in, clearing your cache etc
Add a Reply
Table in Email Upload Images   Link 
Kim Beaul 
5 years ago
RE: Table inside email message. I figured it out!!  

Public Sub PrepareMessage()
    Forms!Email_Form_StudentFieldPlacementHours!MsgSubject = "Accumulated Field Placement Hours for  " & Fname Read More...

All I need now is to indent the table about 1-2 inches.


Reply from Alex Hedley:

  as many times as you need for a single space " " for html or & vbTab for plain text
See this Glossary item for others.
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

10/10/2021Copy Text from Field
10/10/2021Access for Free
10/8/2021Label Resize
10/2/2021Criticisms of Access
10/1/2021Access Developer 32
9/28/2021Track Log On

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access email seminar  Page Tag: whatsnew  PermaLink