Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Seminars > Email >
Access Email Seminar

Learn All About Sending & Receiving Email in Access


 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Buy Now

Welcome

This 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.

You will learn how to send email with and without using Microsoft Outlook. You will learn how to send bulk email batches to groups of customers on set mailing lists using plain text, rich text, or HTML formatted emails. You will build a separate email server database whose job is to handle the processing of email for all of the users on your network. You will learn how to extract data (including attachments) from incoming emails using Outlook, parse the data into your Access tables, and save attachments to your hard drive.

Resources

Main Goals

  • 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 Web Form to Collect Survey Data
  • Extract Files from Access Attachments
  • Track Email Deliverability
  • Email to SMS (Text Message) Gateways
  • Extract Attachment from Incoming Mail

Sample Database

You can download the database that is built in this class so you can test it and make sure it's right for your needs. Note that in the preview database, only the forms that send email via Outlook will work. The SMTP (non-Outlook) code will NOT work because you need to edit the source code and specify your mail server settings, username, and password. These features are only available in the FULL database (which you get a copy of when you buy the seminar). Both 32-bit and 64-bit versions of the database are provided.

Topics Covered

You will start by learning how to send email from Access using Outlook by sending reports from your database directly to a single email.

send email with access and outlook 

 

You will learn about the SendObject and EmailDatabaseObject macro and VBA commands. We'll talk about the Outlook Security Warning and what it means.

sendobject emaildatabaseobject 

 

You will learn how to create nice, formatted emails using Microsoft Word. We will use our Access data in a Word Mail Merge to send multiple emails using Outlook. You will learn about inserting pictures, hyperlinks, and more.

access word mail merge

 

Next we'll build our own email form and send text email direct to Outlook without having to use a database report. You'll learn about the Outlook Application Library and how to add a reference to it in your VBA editor.

automating outlook

 

You'll learn how to send formatted, rich text and HTML messages direct to Outlook. We'll see how to upload images to a public folder on the Web so that your recipients don't have to download them in their email.

rich text html emails

 

Next we'll create a separate form for sending HTML formatted emails. The concept is to create an HTML email in a web editor (or even Word, saved as HTML). Then we just copy and paste the HTML code directly into our email database and click send.

html formatted emails

 

You will next learn how to send attachments as part of your emails via Outlook. We'll create ZIP files, check if a file exists, use the Common Dialog DLL to click on a "select file" button and browse for the files to attach.

sending attachments via outlook and access

 

Next we will see how to automatically export an Access report as a PDF file using VB code. We'll save these PDF files to a folder on your hard drive, and then use them as attachments in outgoing emails. Great for sending customer statements or invoices.

export report as pdf attachment

 

Now we'll start learning how to send bulk email using Outlook. We'll create a customer list form, select specific customers to mail to, generate a loop to cycle through each of the customers, and send email to the selected customers. I will also show you how to disable the Outlook Security Warning so you're not prompted each time you send an email. We'll send balance statements to all customers with a balance on their account over zero dollars.

sending bulk email with access and outlook

 

Next we'll begin a series of lessons on sending email without using Outlook. We will learn how to connect directly to an SMTP mail server. You will still need an email account with an Internet provider, but this will allow you to send directly to their mail server using Access directly, without needing an intermediate program like Outlook between you. We'll learn about the Collaborative Data Object (CDO) programming library.

send email without outlook

 

We will build a more robust form for sending email. You'll be able to select the format (plain, rich text, HTML), specify CC and BCC recipients, and more.

sending email without outlook

 

Next we will learn how to connect to Gmail to send mail using SSL (Secure Sockets Layer). We'll also learn how to send "friendly" names on our emails. You will learn how to send email attachments using this method. You will also lean how to handle errors during the transmission of the email to the server.

send email from access to gmail

 

You will learn how to create an email based on a web page or HTML document. If you know a little bit about web editing, you'll be able to set up a web page, format it as an email (newsletter, for example) and then with a few lines of code send that out as an email, automatically.

send web page as email createhtmlbody

 

Next we'll learn how to use Recordsets to loop through the records of our database in VBA code. This will allow us to more easily send large batches of bulk email. We'll create our own Merge Codes in our emails so you can customize them with phrases like "Dear *FIRSTNAME*" turning into "Dear Joe" when the email goes out.

custom merge fields in emails

 

We'll monitor our email statistics, so when you're sending a large batch you can see how many emails there are total, how many are left, and what the percentage of completion is.

email statistics

 

If you're sending a large volume of emails, you may want to space them out so you don't bog your mail server down. Some ISPs also will complain if you send a ton of emails at once. I'll show you how to program a countdown timer with a delay so you can space your emails out. This will also prevent a flood of traffic on your web server if everyone responds to your email at once.

countdown timer with delay

 

You'll probably have certain emails that you'll send on a regular basis, such as monthly newsletters, weekly balance reports, and so on. Instead of having to re-invent the wheel every time, we'll make a table/form to save our Email Templates. That way you just pick the template, select the customers, customize it a bit if you want, and then click SEND.

email templates

 

You'll also probably want to put customers into different mailing lists, such as your company newsletter, monthly specials, or in my case a group for my Excel students, another for my Access students, and so on. We'll set up a category system where each customer can be in one or more categories. Now all you have to do is pick the Template, pick the Category, and all of those customers get their emails, automatically.

mailing list category management

 

Sending a large batch of email can take a long time. If you have 20,000 emails to send out, that can busy your system up for a few hours. It would be nice to queue up the emails and have another database send them out, right? This can even be a database sitting on another computer somewhere on your network... one that everyone on the network can use. In this lesson I'll show you how to set that up. To be clear, this "database server" will collect the emails from users and send them up to your Email account. You will still need an ISP and an email address. This database just handles all of the email transmission processing so you don't bog down your workstation PC.

 database email server

 

Next we will learn how to read incoming emails and extract the data from them. We'll see how to loop through the emails in our Outlook inbox, collect the data from them, store that data in our Access tables, and put the data in the right fields. We'll see how to send out a User Survey via email and process the data when the users return the email with information filled in.

read incoming email from outlook

 

If you have your own web site with Microsoft (Windows) hosting, this lesson will allow you to set up a form on your web site using HTML and ASP (Active Server Pages) to collect user data. When they submit the data it will come to you via email and you can use the techniques from the previous lesson to read and parse the data.

get user data from web site

 

Many people use the Attachment field type in Access databases to store files. I will show you how to extract those files to your hard drive using VBA code so that you can then use them as email attachments.

extract attachment fields

 

We will also discuss tracking email deliverability with delivery status notifications and read receipts. We'll talk about sending email as text messages using an SMS gateway, and we'll see how to extract attachments from incoming emails and save them to a file folder.

As you can see, if you want to be able to send and receive emails using Access, this is the perfect seminar for you. You will learn everything mentioned above. You will have access to the full database that we build in class with all of these features. If you have any question whether this seminar is right for you, please feel free to contact me.

Pre-Requisites

This is a Developer-Level Seminar. There will be a lot of VBA. It is strongly recommended that you have completed my entire Access Beginner and Expert series. My Developer 1 class is highly recommended so you understand the basics of programming in VBA. If not, at least watch my free Intro to VBA video. 

This course stands alone, however it is very strongly recommended that you at least know everything in my Access Beginner series (1-9) and the first three (3) lessons of my Expert series. You will also need an email account and a working installation of Microsoft Outlook to use the lessons involving Outlook. If you wish to use the lessons on collecting data via a web page, you will need Microsoft web hosting with ASP. Again watch the intro video (above) for a complete listing of pre-requisites for this course.

Version Notes

I am using Access 2013 in this seminar, however the lessons are perfectly valid for all versions of Access from 2003 and later. It's currently 2022 and I just recently verified that everything in this seminar still works with Access 2019 and Office 365.

The common dialog box (used to select a file attachment) will not work with 64-bit Access. I provide an alternative. The lesson on disabling the Outlook security warnings may not work in older versions of Office. Everything else works just fine. Watch the intro video (above) for a complete list of version information.

Enroll Today

Enroll now so that you can watch these lessons, learn with us, post questions, and more.

Questions?

Please feel free to post your questions or comments below. If you are not sure as to whether or not this product will meet your needs, I'd rather help you before you buy it. Remember, all sales are final. Thank you.

Keywords

send email from access, export report as pdf, send email attachments, bulk email with access, ssl, access outlook inbox, read incoming mail, collect user data, surveys, email to text message, extract attachments, database, microsoft access, access tutorial, email without outlook

 

Comments for Access Email Seminar
 
Age Subject From
19 daysAll Features via GmailAmanda McDonald
8 monthsTrust Ctr Never show blockedSusan Socrates
2 yearsOutlook.comKamil Segebre
2 yearsEmail AutomationTeegan Murray

 

Start a NEW Conversation
 
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
 
Subscribe
Subscribe to Access Email Seminar
Get notifications when this page is updated
 
 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/28/2024 10:29:18 AM. PLT: 0s
Keywords: access seminar send email from access, export report as pdf, send email attachments, bulk email with access, ssl, access outlook inbox, read incoming mail, collect user data, surveys, email to text message, extract attachments, database, microsoft access,  Page Tag: whatsnew  PermaLink  Microsoft Access Email Seminar