smtp from Access

[Joe]

I have recently completed a database, which sends e-mails
automatically. I was hoping to be able to send these
reports without user intervention but the recent security
changes in Outlook will not allow this to happen. I have
addressed this issue on the Outlook community and have
been advised that one solution is to use smtp server as
the mailer (we have VPOP3 installed on the network. which
has virus protection on the gateway) Does anyone know if
it is possible to achieve this directly from Access and if
so where I can get the information.
Thanks in advance
Joe

 

[Andy Debaere]

Yes,

I've succesfully used the following 2 smtp-engines with access-vb
- Jmail : http://www.dimac.net
- Osmtp : http://www.ostrosoft.com/smtp_component.asp

Both are com object
I prefer Jmail for the following reasons:
- I can be late bound and still you can check the status of the message
(send or failed), with osmtp you can only check this if you reference it
(early bound)
- Osmtp still needs visual basic runtime modules, Jmail doesn't so this
eases distribution (Jmail = 1 file ,Just copy and register)

Good luck,
Andy