Microsoft Access Email Seminar
By Richard Rost

8 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:

Send 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

Updates

You may have to turn 2-factor authentication OFF for your Google account if you're having problems sending mail. I'd recommend creating a 2nd account just for sending mail from Access. This way your primary account is still safe and secure with 2FA.
You may need to make an App Password for your Google account. Go into your Google Account settings (not Gmail, your Google Account) and go to Security - Signing in to Google - App passwords. There you can setup a special username and password just for your Access app to send email thru your Gmail account. Not sure if I covered this in the seminar or not because it wasn't required at the time.

First Email Upload Images Link
Steffen Morning
7 years ago

Very interesting class and it shows almost what I need. My problem is that I wish to import and move ONLY the currently selected e-mail in Outlook and not all of them. I figure a simple change to the line "For Each oMailItem In oInbox.Items" would do the trick but I don't know how. Can I simply change the word "Each" to "Selected"?

Reply from Alex Hedley:

I'll need to look at the code.

For Each is a keyword used in the loop, it's the oInbox.Items that would need to be checked for first.

Do While True
    count = count + 1

    If count = 10 Then
        Exit Do
    End If
Loop

Show All Comments