<div>
Thanks. That got me searching. I found this code and it is working perfectly:<br />
<br />
Set emailObj = CreateObject(&quot;CDO.Message&quot;<wbr />)<br />
emailObj.From = &quot;russ@mydomain.com&quot;<br />
<br />
emailObj.BCC = &quot;anyone@gmail.com&quot;<br />
<br />
emailObj.Subject = &quot;Test CDO...please delete.&quot;<br />
emailObj.TextBody = &quot;Testing from Russ&quot;<br />
<br />
Set emailConfig = emailObj.Configuration<br />
<br />
emailConfig.Fields(&quot;<a href="http://schemas.microsoft.com/cdo/configuration/smtpserver" rel="ugc nofollow">http://schemas.microsoft.com/cdo/configuration/smtpserver</a>&quot;) = &quot;mail.mydomain.local&quot;<br />
emailConfig.Fields(&quot;<a href="http://schemas.microsoft.com/cdo/configuration/smtpserverport" rel="ugc nofollow">http://schemas.microsoft.com/cdo/configuration/smtpserverport</a>&quot;) = 25<br />
emailConfig.Fields(&quot;<a href="http://schemas.microsoft.com/cdo/configuration/sendusing" rel="ugc nofollow">http://schemas.microsoft.com/cdo/configuration/sendusing</a>&quot;) = 2<br />
emailConfig.Fields(&quot;<a href="http://schemas.microsoft.com/cdo/configuration/smtpauthenticate" rel="ugc nofollow">http://schemas.microsoft.com/cdo/configuration/smtpauthenticate</a>&quot;) = 1<br />
emailConfig.Fields.Update<br />
<br />
emailObj.Send
</div>


<div>
Yes, CDO is another option, which I should have mentioned.<br />
<br />
Jim.
</div>


<div>
Free is great...if it works! :-)
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts!<br />
I need to send emails from within Access97 using an SMTP server. I can send now using the Outlook object, However, I need to use a 3rd party email relaying service so I need to specify:<br />
1) SMTP server <br />
2) Outgoing Port 587<br />
3) User<br />
4) Password<br />
<br />
Can anyone help? High points for a speedy and working solution!<br />
Thanks!
</div>
</div>


Hello Experts!
I need to send emails from within Access97 using an SMTP server. I can send now using the Outlook object, However, I need to use a 3rd party email relaying service so I need to specify:
1) SMTP server 
2) Outgoing Port 587
3) User
4) Password

Can anyone help? High points for a speedy and working solution!
Thanks!

Sending email using SMTP in Access 97

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.