Info on setting up OAuth2 with Excel VBA

[SeniorTom]

I have an Excel project that has been sending email for the last 3 years and now gmail has put restrictions on Username and password access. I have seen post stating I need to use OAuth2 now, but I can't seem to find any example of how to do it. I think I understand the big picture, but my experience is limited in the details.

My error is "The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available"

Can anyone direct me to some example code?

 

[SeniorTom]

I have tried to setup Quickstart, but get hung up on Domain name. I have a single google group with one user on my home network. Any thoughts on what domain I can use?

Regards,
Tom

 

[Kyle123]

Could you link to the post that says you need to use OAuth2? It's quite complicated

 

[SeniorTom]

Could you link to the post that says you need to use OAuth2? It's quite complicated

Having problems finding it, but my original question has been resolved

 

[smozgur]

Having problems finding it, but my original question has been resolved

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[SeniorTom]

Sorry, I didn't know if I could delete the thread. Is there a way to remove it when it is no longer relevant?

 

[SeniorTom]

I have an answer/solution from DiamTo at stackoverrflow

No longer able to send e-mails with VBA and google smtp - Additional Info

Similar problem to "Resca's" Utility to send email to Gmail stopped working after google implemented OAuth. I have an excel workbook using VBA to ONLY SEND individual gmails to multiple “...

stackoverflow.com

 

[Fluff]

In future when cross-posting, please provide the link(s) at the time you cross-post, not sometime later.
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!