Version 2211           Approx 0.5 MB                 First Published 11 Feb 2015                 Last Updated 14 Nov 2022


This is used to test sending emails directly from Access without using Outlook.

The app allows users to test the settings for sending emails from Access using collaborative data objects (CDO)


It can be used to send HTML emails as well as plain text. One or more attachments can optionally be included.

This is an example HTML email message sent by the application including formatted text, an inline image and an attached file


NOTE:
Although images can be included in any HTML email, many email programs block these by default for security reasons.
Whilst some email programs such as Outlook will allow you to approve the images, it is often both simpler and more reliable to include images as attachments.

If the settings are correct, you will send this message after the Send E-Mail button is clicked.


If there are issues, error messages are displayed to assist with fixing the problem(s).


A Help file is supplied which explains the meaning of all error messages that may occur.






NOTE:

1.   This application is compatibile with both 32-bit & 64-bit Access

2.   Google has added additional security to GMail which effectively blocks email sent from any app it considers less secure (including Outlook / Access).
      The supplied Help file includes details of two solutions, both of which require a change in the security section of your Google account settings

3.   The previous version(2201) included updated code to handle UTF-8 encoding (required for sending email in non-Latin scripts such as Arabic.
      Thanks to Access World Forums member @alvingenius (Motaz Hakim) for both alerting me to the issue and for providing the code modification required.

4.   The latest version (2211) fixes a minor error in the SendEMail code



Useful links

      Philipp Stiefel :   Sending Emails from Access with VBA and CDO

      Daniel Pineault :   VBA - Using CDO Mail To Send E-mails



Download

      Click to download:   CDO EMail Tester v2211     (zipped)



Feedback

      Please use the contact form to let me know whether you found this article / example app useful or if you have any questions.



Colin Riddington           Mendip Data Systems             Last Updated 14 Nov 2022

Return to Example Databases Page

Return to Top