Gmail from MS Access, VBA, Excel, Word…

Gmail from MS Access, VBA, Excel, Word…

"Send a Secret Email"

Escape From Outlook

Video 1  (0:56)

Escape From Outlook

Microsoft tightly combine their applications together however sometimes it’s nice to escape from Microsoft Products and use others.  Here I demonstrate how you can use Google Mail to send out an e-mail from an Internet connected PC, and you can also do this covertly!
 
This Example is From:
Windows® XP Under the Hood, Pg. 266 Chapter 6 Messaging and Faxing ObjectsExtract
This basic example sends a simple, no-frills text message every time the script is run: Example File: script0603.vbs As you can see, the original file was a VBScript file; I have converted this to VBA.

Video 1  (0:56)

Nifty Access YouTube Thumb Nail
Play Video

Sending an Attachment:-​

Alan Asked:-

If I wanted to take it to the next level and add an attachment to the Build a Message section of the code.  Under oMsg, what code would I add to have it grab a report or query and email it as an attachment.

If I wanted to add an attachment:

Add a line after “.textBody” and before “End With” like so:

.textBody = “From Keyed in Email Address”
.AddAttachment “H:\ADrive\YourFileName.txt”
End With

… …

How to send email using Gmail via Excel VBA

Gmail from Excel

Video 2 (16:09)

This YouTube “How to send email using Gmail via Excel VBA” from Dinesh Kumar Takyar demonstrates how to send Gmail from MS Excel with VBA. 

Video 2 (16:09)

More Info on Gmail from Excel:-

… …

Google - Sign in using App Passwords

To use Google verification you will need an Application Specific password…

“Google Verification – App Passwords”

Google App Password

… …

Gmail with VBA Extra's

Retrieve Gmail with VBA?

Don't Know...

However it might be possible to knock something up:-

… …

Nice Article From MicroSoft

Collaboration Data Objects: Using E-Mail in Your Application

Extract:- How to incorporate e-mail into your client applications through the use of Collaboration Data Objects, a high-level set of COM objects that allow easy access to e-mail systems

EMail Tester

There’s a sample database on Colin’s site which looks interesting. Click on the link below and follow the instructions. I checked with Colin and it does use CDO. In any event it looks like an interesting example, well worth exploring. 

… …

More Useful Stuff HERE:-

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.