<div>
Thanks guys. &nbsp;<br />
<br />
VBMAPI - may indeed be a useful tool for me. &nbsp;But, I also want to provide something that is independent of Outlook (not all of my clients use it).
</div>


<div>
BTW, CDO should support TLS....<br />
<br />
Jim.
</div>


<div>
Thanks everyone - I'll take a look at all of the suggestions.<br />
<br />
Much appreciated.
</div>


<div>
<div class="content wysiwyg-content">
I need to send out emails through Access. &nbsp;Usually, it's just a one-off, but sometimes we need to send out almost 1000. &nbsp;In the past I have used CDOSYS, but have come up against two issues in the past:<br />
<br />
1) TLS security settings don't seem to be fully catered for (it works fine as SSL and no security)<br />
2) I sometimes need a different FROM address to the reply. &nbsp;This is so replies and bounce-backs can be handled by a central user.<br />
<br />
So my question is this. &nbsp;Is CDOSYS the right way to go, or is there a better plug-in that may offer us more?
</div>
</div>


I need to send out emails through Access.  Usually, it's just a one-off, but sometimes we need to send out almost 1000.  In the past I have used CDOSYS, but have come up against two issues in the past:

1) TLS security settings don't seem to be fully catered for (it works fine as SSL and no security)
2) I sometimes need a different FROM address to the reply.  This is so replies and bounce-backs can be handled by a central user.

So my question is this.  Is CDOSYS the right way to go, or is there a better plug-in that may offer us more?

CDOSYS or something better...

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

An email client, email reader or more formally mail user agent (MUA) is a computer program used to access and manage a user's email. A web application that provides message management, composition, and reception functions is sometimes also considered an email client, but more commonly referred to as webmail.

Email Software

Interactions between email servers and clients are governed by email protocols. The three most common email protocols are POP, IMAP and MAPI. Most email software operates under one of these (and many products support more than one).  The correct protocol must be selected, and correctly configured, if you want your email account to work.