First Post

[Wayne1967]

I am new to this forum and am working on a project for my own use. I have an access database with contact names and email address. My contact form has two buttons, one to send an email via Outlook and one to send an email via Gmail. I have Outlook working fine with opening Outlook and populating the To field. The Gmail button opens Gmail and presents the new message from but I can't figure out how to populate the To field. Any help would be appreciated. Using VBA Code

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[theDBguy]

Hi. Welcome to AWF!

I would suggest you post your question with more details, such as showing us your code, in a new thread in maybe the Forms forum.

 

[Gasman]

I am new to this forum and am working on a project for my own use. I have an access database with contact names and email address. My contact form has two buttons, one to send an email via Outlook and one to send an email via Gmail. I have Outlook working fine with opening Outlook and populating the To field. The Gmail button opens Gmail and presents the new message from but I can't figure out how to populate the To field. Any help would be appreciated. Using VBA Code

Always my first point of call.

send email gmail vba - Google Search

www.google.com

 

[Uncle Gizmo]

I blogged about it years ago, so it may well be out of date now. I do know that Google changed a few things with Gmail.

However it might give you a start

Gmail from MS Access, VBA, Excel, Word… - Nifty Access

Gmail from MS Access, VBA, Excel, Word… "Send a Secret Email" Escape From Outlook Video 1 (0:56) Escape From OutlookMicrosoft 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...

www.niftyaccess.com

 

[Uncle Gizmo]

Here's the VBA code to email from Gmail:-

Code for Gmail From Access - Nifty Access

Code for Gmail From Access This Code allows you to send email directly from Microsoft Access, Excel, word, etc with VBA. Since I wrote this code Google have updated the way you access their Gmail system. You might have to jump through hoops to get it working! If you can give me any advice on

www.niftyaccess.com

 

[Uncle Gizmo]

Also, Colin - @isladogs has some useful info on his website here:-

CDO EMail Tester

Used to test sending HTML or plain text emails directly from Access without using Outlook. Attachments can also be added. Attachments can also be added. EMail settings can optionally be included in the email body.

www.isladogs.co.uk