[AccessD] VBA sending emails

[Jim Dettman]

FYI, like BLAT, vbSendMail is limited to 32 bit as well.

If you want to talk to a SMTP server directly, you'd need to use a 3rd party
tool.  i.e.:

https://www.fmsinc.com/Products/Emailer/index.asp

Or write your own.

CDO is depreciated (still works but has no support for oAuth).  With
Outlook, you can use late binding so you don't have to set a reference, but
that is only going to carry you so far into the future.  For the future,
looks like we are going to be looking at using some sort of REST API most
likely.   Microsoft has removed COM support from the new Outlook, which is
where they are taking everyone.  Here's some info on the API:

https://learn.microsoft.com/en-us/graph/api/resources/mail-api-overview?view
=graph-rest-1.0

And some demo code:

https://www.devhut.net/how-to-send-e-mails-via-outlook-using-the-microsoft-g
raph-api/

 But mind you, I don't know if Microsoft is landing on this as a solution
long term.   They are keenly aware of the problem in removing COM support
from Outlook, but so far have been mum on any solution.

Jim.



-----Original Message-----
From: AccessD On Behalf Of Paul Hartland via AccessD
Sent: Friday, June 21, 2024 2:16 AM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Cc: Paul Hartland <paul.hartland at googlemail.com>
Subject: Re: [AccessD] VBA sending emails

Have you looked into vbSendMail ?

On Fri, 21 Jun 2024, 00:44 Ryan W, <wrwehler at gmail.com> wrote:

> If I wanted to send emails via SMTP without CDO or Outlook references, I
> want to say someone here had some code to do it?
>
> Anyone got a link to that?
>
> TIA
>
>
> Sent from my iPhone
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com