Jim Dettman
jimdettman at verizon.net
Mon Aug 6 07:54:29 CDT 2007
Rocky, I'm not sure "better" would be the correct word, but I do find it simpler. I need only one .DLL to be registered to make the code work. BLAT is even simpler yet, but unless you use the DLL version, you have no error checking or real control over it. And last I checked, the .DLL version was lacking several key features and was a rev or two behind the command line interface. CDO has come along way. Early on there were multiple versions and they all didn't work the same. I've been quite happy with the direct SMTP code I've been using and have not needed to develop anything more sophisticated, so I have not taken another look at CDO in a long time. I believe that you still need to rely on it being installed and it only comes with certain Microsoft products. There is no separate download that I'm aware of. This is another reason I've not used it as I like to provide my apps with everything that's required and not rely on external products if at all possible. But it certainly has a lot more capabilities then sending e-mail and it may be worth starting down that road to get a handle on it for the future. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Sunday, August 05, 2007 11:44 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Need SMTP Code Thanks. Looks easy enough. Is it better than the CDO approach? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Sunday, August 05, 2007 7:28 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Need SMTP Code Rocky, see: http://www.freevbcode.com/ShowCode.Asp?ID=109 works well with Access. Have used it for years. Only requires one .DLL Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Saturday, August 04, 2007 9:10 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Need SMTP Code Dear List: I have a lot of Access sites bookmarked but can never find what I need in them. I'm looking for some code to handle email from Access using SMTP. Does anyone know if there's a module I can crib from one of the many Access sites? MTIA Rocky -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.11.4/936 - Release Date: 8/4/2007 2:42 PM -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com