![]() That said, it isn’t for the faint of heart as the coding required is quite extensive and definitely not for the novice programmer. The built-in WinSock API opens the door to a multitude of possibilities (LAN, FTP, e-mail, and much more). FMS Inc’s Total Access EmailerįMS Inc’s Total Access Emailer is a paid Access Add-In that seamlessly integrates into your Access application. Outlook Redemption is a paid COM library that must be registered on each computer that uses it and can be used in a multitude of programming languages, not just VBA. VbMAPI is a paid solution created by Wayne Phillips, so you can be sure it is good (all his solutions are top notch)! The advantage over the vbSendMail technique is that there are no external files required (no dlls). The major drawback with this approach is that is appears to require installing vbsendmail.dll and the mswinsck.ocx with rgsvr32 and then setting a VBA Reference to SMTP Send Mail for VB6.0. This is one technique I have not personally used, but several of my fellow MVPs have used it and recommend it. ![]() VbSendMail is a free dll based solution for sending e-mail. To implement it using VBA, you basically build the necessary command as a string and then use the Shell function to execute it. It worked beautifully and is very easy to use. I actually used it as part of one of my very first databases when I was still in the corporate world. BLATīLAT is a free command-line utility for sending e-mails. Refer to the links provided for each for more information, examples, purchase details (if applicable). Note that the following are not part of the Demo Database. This is where including yourself in the To/CC/BCC can become necessaryĪlthough the above covers most use cases, there are a number of other techniques that can be employed depending on the situation, and there are even more than the one briefly covered below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |