Microsoft Access - Google REST API - Send Email via Gmail

Рет қаралды 789

D Pineault - Tech, Programming and more

Күн бұрын

Demonstrating how we can implement Google's REST API in Microsoft Access to work with any aspect/service we'd like. In this video, I show you how you can send an e-mail through your Gmail account using simple HTTP requests.
With this approach, we communicate directly with Google's servers and do not pass through any email client.
This is all in preparation for the 'New Outlook' and the fact that it will no longer support VBA, so Outlook Automation will cease to work. Using a REST API approach may be the only way to continue to interact and send e-mails, work with calendars, contacts once this all happens.
I will be releasing a video, in the near future, on how to implement the Microsoft Graph REST API to send e-mails via an Outlook account. So stay tuned for that.
Article(s) on this Subject:
• www.devhut.net/how-to-send-e-...
My Links:
🏭 www.cardaconsultants.com/ (business)
📢 www.devhut.net/ (blog)

Пікірлер: 33

@johnclark851 2 ай бұрын

I put this through its paces this morning. Good stuff!

@DanielPineault 2 ай бұрын

Glad you enjoyed it!

@sudarsonoliyis 2 ай бұрын

Exactly what I need

@DanielPineault 2 ай бұрын

Glad you enjoyed it.

@BenMenegazzo 2 ай бұрын

Hi Daniel, this was a very informative video and associated article. Personally, I would love to see an article (or any information really) relating to working with the Xero API.

@DanielPineault 2 ай бұрын

Noted

@bumpersmith 2 ай бұрын

Thank you, Daniel. I am struggling with a replacement for outlook to send our little town's historical society's newsletters. Hopefully, I can study this and make it work with modifications for a replacement for my current vba code to email the newsletters. Any help to start to steer away from MS is a plus in my opinion. Keep up the good work.

@DanielPineault 2 ай бұрын

My pleasure. CDO Mail is another viable option in certain scenarios Or perhaps switching to an alternate email client which still allows for automation (I'm thinking of Thunderbird for instance).

@bumpersmith 2 ай бұрын

@@DanielPineault Yes, I am looking at Thunderbird. I have watched your video that includes Thunderbird but have not had time to download and try it. I did try your sample on CDO but could not get it to work for me. I am sure it was because I was not able to understand how to get the correct Gmail parameters.

@TheRealWillM 2 ай бұрын

Yes for appointments and activity tracker if you have time (as well)

@DanielPineault 2 ай бұрын

Thank you for your feedback.

@redrobienahouseofpaws Ай бұрын

I just can't thank you enough for this. It is fantastic stuff. Can I ask you how to add attachments to the email. It is way to complicated for me at this stage to work it out

@DanielPineault Ай бұрын

It not something that I've explored so far. I know it's possible and it is on my 'to do' list because it is a critical aspect of sending emails. If/when I explored it, I'll update my articles ...

@redrobienahouseofpaws Ай бұрын

@@DanielPineault I'm looking forward to that, Daniel. Could you also include "From Email Address", please?

@DanielPineault Ай бұрын

Do you mean sending on behalf of?

@redrobienahouseofpaws Ай бұрын

@@DanielPineault Just the option to enter the sender's name instead of the sender's email address which is used by default.

@nutsonbikes 2 ай бұрын

Wow, this looks monstrously more complicated than COMS! Great stuff though!! We use M365 at my company and I have a project oriented db which has user tasks. Can tasks in to do or even Planner be accessed?

@DanielPineault 2 ай бұрын

Sure! Take a look at learn.microsoft.com/en-us/graph/todo-concept-overview Of course it's more complicated. When using COMs we simply use built-in methods, functions and Outlook does everything else for us (established connection, send the request, ...). So when we have to replace all of that there's a considerable amount of extra code required.

@andreask18 2 ай бұрын

Thank you Daniel. I tried running the demo but I am getting plenty of script error when running Google Authentication in the web browser control. I was able to login on the web browser control but when it was time to click Allow or Deny, both buttons are disabled and I suspect because of the script errors. I was able to run the Google Authentication page just fine on a regular browser. Is there any setting special setting I need to set? I understand that web browser control is using Internet Explorer.

@DanielPineault Ай бұрын

Sound like you're using the original web browser control. You can try setting the Feature Browser Emulation, refer to: www.devhut.net/everything-you-never-wanted-to-know-about-the-access-webbrowser-control/ But I too experienced issues with Microsoft's authentication, unlike with Google's, and had to switch to using the Modem Web Browser control to get around the issues.

@ingridglorieux6414 Ай бұрын

Thank you very much for this demo!!! So interesting! I have an error on this line: HF_EncodeURIComponent = CreateObject("HTMLFile").parentWindow.encodeURIComponent(sURI) a suggestion on how to solve this?

@DanielPineault Ай бұрын

Are you running 32 or 64-bit?

@ingridglorieux6414 Ай бұрын

@@DanielPineault 64 bit

@DanielPineault Ай бұрын

I'm afraid I don't have a 64-bit system with a version of Access that has the Modern Web Browser control. I just don't use 64-bit. It causes more issues than it ever resolved. So I'm not in a position to do any troubleshooting. You could try swapping the function for another one found on my blog: www.devhut.net/vba-url-encode-uri-encode/

@DanielPineault Ай бұрын

Perhaps I'm jumping the gun here. What is the error you are getting? What is the URI you are passing? Have you tried not enocding the URI, perhaps it will works without encoding.

@ingridglorieux6414 Ай бұрын

@@DanielPineault Error number 438