[AccessD] VBA sending emails

[Stuart McLachlan]

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