Replied 4 August 2017, 5:58 am EST
<div class="Section1"><font face="Arial" size="2"><span>You have several options to send a
report via email. A very nice and easy-to-use library is
vbSendMail. The one
drawback of this library is that it doesn’t support encrypted smtp (SSL). If you
cannot use this library because of this drawback, you can use:</span></font>
<li class="MsoNormal"><font face="Arial" size="2"><span>Collaboration Data Objects :
</span></font>Sending Email Using CDO and
MAPI
</p><li class="MsoNormal"><font color="black" face="Arial" size="2"><span>Microsoft MAPI
controls 6: </span></font><font color="black"><span>Sending
Email With MAPI Components in Visual Basic</span></font>
</p><li class="MsoNormal"><font face="Times New Roman" size="3"><span>Using the </span></font><font face="Arial" size="2"><span>Outlook object model:
</span></font><b><font face="Times New Roman"><span>How do I send an email using
Outlook?</span></font></b><font face="Arial" size="2"><span> </span></font></p>
<font face="Arial" size="2"><span>No doubt there are other options to
send email including third party controls. I’ve modified the sample from the
devarticles using the MAPI controls to send a report in several attachments. I hope the resources above prove helpful if this application doesn't suit your needs
</span></font></div>
2006/10/SendMailMapi.zip