CDO EMail Tester (1 Viewer)

Status
Not open for further replies.

isladogs

CID VIP
Local time
Today, 06:43
Joined
Jan 14, 2017
Messages
14,028
Attached is a simple utility for testing the settings for sending emails from Access using collaborative data objects (CDO).

The zip file contains the Access utility (.accdb) & a Word help file (.docx)
I've had to zip it as the site won't allow uploading of docx files!

If the email fails due to incorrect settings, the Word doc explains what the error code means so it can be fixed.

To use this utility copy the database & Word doc into the same folder

Any comments welcomed.

I have included all error codes I have experienced, but if anyone using this gets another code, please do let me know

EDIT 02/10/2018
This version only works in 32-bit Access
Updated version in post #3 works in both 32-bit & 64-bit Access
 

Attachments

  • EMail Tester.zip
    180.3 KB · Views: 852
Last edited:

Ksabai

Registered User.
Local time
Yesterday, 22:43
Joined
Jul 31, 2017
Messages
104
Re: EMail Tester

I have a 64Bit Access, unable to run as iam getting PtrSafe Error while compiling
 

isladogs

CID VIP
Local time
Today, 06:43
Joined
Jan 14, 2017
Messages
14,028
Apologies - thought I'd sorted that out before I uploaded it last year
Updated version attached which works in both 32-bit & 64-bit Access
 

Attachments

  • EMailTester v1810.zip
    194 KB · Views: 331
Last edited:

isladogs

CID VIP
Local time
Today, 06:43
Joined
Jan 14, 2017
Messages
14,028
Following an question via PM by AWF member ellenr, I've discovered a new issue sending email using CDO using a GMail account
Google has added additional security which effectively blocks email sent from any app it considers less secure (including Outlook and Access).
This results in an incorrect password error when you enter your correct account details.

There are two possible solutions both of which require a change in the security section of your Google account settings:
a) allow less secure apps - if this is applied, GMail will again work via CDO.
However, this is not available if you have switched on two step authentication

b) set app password = enter a name for the app e.g. CDOEMailTester and it will generate a unique password for that app and your account.
Enter that in place of your usual password & CDO email for your GMail account will again work perfectly!

See these links for more info:
a) https://support.google.com/accounts/answer/6010255?hl=en&ref_topic=7188673#
b) https://support.google.com/accounts/answer/185833?hl=en

Updated app to v1903 with new help file - both attached
 

Attachments

  • CDOEMailTester v1903.zip
    213.2 KB · Views: 209
Last edited:

isladogs

CID VIP
Local time
Today, 06:43
Joined
Jan 14, 2017
Messages
14,028
Something I’ve been meaning to do for a long time
I’ve just updated my CDO Email Tester to include HTML Email as well as plain text.

Unzip the attached file & keep all files in the same folder
If you use HTML email, it will automatically include formatted text and an inline image.



Hope this is of use to others
 

Attachments

  • CDO EMail Tester v1908.zip
    393.7 KB · Views: 214
  • Capture.PNG
    Capture.PNG
    73.9 KB · Views: 681
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom