Welcome to Access Email. Total running time is 11 Hours, 49 Minutes.

Lessons

•  00. Intro
•  01. Sending Email Manually
•  02. EmailDatabaseObject SendObject
•  03. Email Merge to Word
•  04. Automating Outlook Email 1
•  05. Automating Outlook Email 2
•  06. Automating Outlook Email 3
•  07. Attachments in Outlook Email - Notes
•  08. Create PDF Access Attachments
•  09. Mass Email Using Outlook
•  10. Send Email Without Outlook 1 - Notes
•  11. Send Email Without Outlook 2
•  12. Send Email Without Outlook 3
•  13. Send Email Without Outlook 4
•  14. Email from HTML or Web Page
•  15. Bulk Customized Email 1
•  16. Bulk Customized Email 2
•  17. Bulk Customized Email 3
•  18. Bulk Customized Email 4
•  19. Bulk Customized Email 5
•  20. Bulk Customized Email 6
•  21. Mailing List Management
•  22. Your Own External Mail Server 1
•  23. Your Own External Mail Server 2
•  24. Your Own External Mail Server 3
•  25. Reading Email From Outlook
•  26. Collecting Data Via Email
•  27. Collecting Data Via Web Page
•  28. Extracting from Attachment Field
•  29. Miscellaneous
•  30. Review

Resources

• Student Forum for Email Seminar (for posts involving discussion of source code)
•  Database Files
•  PDF Handbook
• Source Code in Code Vault
• Full Course Outline
• Skills Test Quiz - Under Construction
• Certificate of Completion
• Post-Class Survey

New 64-Bit PickFile Function

• This seminar was released back in 2014 when 64-bit Office was relatively new and very few people had upgraded to it. At the time, in fact, Microsoft was recommending that only people with a specific need for 64-bit actually upgrade to it. I belonged to that camp. Flash-forward to 2022, and now most people are using 64-bit Office, and in fact it is the default standard. So, I had to replace the SelectFile function that you see in video 7 (Attachments) with a new PickFile function. All you have to do is put PickFile in the module where all the SelectFile stuff is and change anywhere you see:
  
     SelectFile (Me, FolderName)
  
  to
  
     PickFile (FolderName)
  
  That's it. I've updated the code on the Source Code page in the Code Vault, and I've updated the database file in the ZIP file archive that you can download. It's in the "Access-Email-Seminar-Complete.ZIP" file. Look in the Email-Seminar-NEW.accdb file. That's it. Super simple.

Gmail Update

• To use this Seminar code with Gmail, you will need to make a Gmail App Password for your Google account. I did not cover this in the seminar because it wasn't required at the time. That link contains a video that walks you though it.

Other Updates

• Note that sending email via CDO.Message as shown in Lesson 10 does NOT work with Microsoft Exhange Server as of August of 2021. According to this page: "The MAPI/CDO library has been replaced by Exchange Web Services (EWS), Exchange ActiveSync (EAS), and Representational State Transfer (REST)^* APIs. If an application uses the MAPI/CDO library, it needs to move to EWS, EAS, or the REST APIs to communicate with Exchange 2019." Thanks to Moderator Scott Axton for finding this one.

Questions?

Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Subscribe for Updates

If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.