how to open gmail from inside access (vba) and pre-populate message fields

Hi. I'm looking for pointers on how best to open gmail from an access app. I've found a nice video how to send a message automatically from vba (Send An Email From Your Gmail Account with VBA | Excel VBA Tutorial - YouTube

), but not how to open the browser to the compose message page with the fields filled in.

The users use gmail, not outlook (or live.outlook.com). Outlook would have been better for me.

What the user wants to do is review a standard message, personalize it, and then send it. Messages will likely have one or two attachments and may have a cc.

I've found how to do this on android, java - How to open gmail in android - Stack Overflow. Is there anything in the Microsoft space that will do the same thing, but from inside Office (Access)?

Thanks,

Mike


Answer
Answer

You'd need to use the API

--
Daniel Pineault
Microsoft MVP 2010-2021

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated March 22, 2024 Views 1,122 Applies to: