[AccessD] VBA sending emails

[Ryan Wehler]

I would be authenticating with a server that knows me.

On Fri, Jun 21, 2024 at 9:58 AM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Just to be clear, are you talking about acting as an SMTP server and
> sending directly to the
> destination domain's mail server (using their MX record)  or just acting
> as an MSA (mail
> submission agent) and connecting  to an SMTP server that knows you?
>
> Blat does the former.
>
>
> On 21 Jun 2024 at 7:24, Ryan Wehler wrote:
>
> > 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:52AM 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
> > >
> > --
> > 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
>