Microsoft Access - Google REST API - Send Email via Gmail

[@johnclark851]

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

[@DanielPineault]

Glad you enjoyed it!

[@continental_drift]

Great demo! Thanks.

[@DanielPineault]

Thanks for watching!

[@dilligaf_at_all]

In the article on your website, you finished by saying "In the coming days I will be working further on both articles to add more information." Did this happen and where might I find it? Thanks

[@DanielPineault]

No, I haven't revisited the Google API any further and rather concentrated on the Microsoft Graph API. I will eventually revisit it, I just don't know when. In reality, I've played around, developed code, but haven't had the opportunity to write the article or create videos on the subject matter.

[@andreask18]

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.

[@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.

[@TheRealWillM]

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

[@DanielPineault]

Thank you for your feedback.

[@BenMenegazzo]

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]

Noted

[@bumpersmith]

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]

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]

@@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.

[@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

[@nutsonbikes]

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]

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.

[@sudarsonoliyis]

Exactly what I need

[@DanielPineault]

Glad you enjoyed it.

[@romeusCM]

Saludos, envia este mensaje : Acceso bloqueado: Error de autorización Client missing a project id. Si eres un desarrollador de esta app, consulta los detalles del error. Error 401: invalid_client

[@DanielPineault]

¿Ha configurado la variable en el módulo mod_Google?