[AccessD] VBA sending emails

[Ryan Wehler]

Thanks. Yes, part of this is avoiding Outlook due to future deprecation.

I could have sworn someone one here had a solution that didn't rely on a
third party tool or library. Maybe I dreamt about it! ha ha


On Fri, Jun 21, 2024 at 6:52 AM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

>
> 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
> <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/
> <https://www.devhut.net/how-to-send-e-mails-via-outlook-using-the-microsoft-graph-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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>