Is it possible to send email from Access using GMail

[jpg250]

I have seen plenty of examples to send emails with attachments via Outlook. I want to send emails from Gmail. Is it possible to specify the sender email address?

[June7]

Bing: Access VBA gmail

This one says requires gMail to be your email server
http://www.blueclaw-db.com/access_email_gmail.htm

This one says an internet connection is required
http://msaccessroi.blogspot.com/2013...l-from-ms.html

[jpg250]

Thank you June. This is just what I was looking for.

[ItsMe]

I have not had any luck using CDO with a GMAIL account. Did you get it to work?

[jpg250]

I have not had any luck using CDO with a GMAIL account. Did you get it to work?

Not yet. I'm just about to start experimenting, but I found other discussions where people could not get it to work, so I'm not very hopeful.

[ItsMe]

You might try putting the GMAIL settings in a program like Outlook and then create an Outlook Object in Access using VBA. You can send an email through your Outlook app.