Max Sherman
max at sherman.org.uk
Sun Aug 5 14:03:21 CDT 2007
Hi Rocky, Better to have too much then none at all, but when you come to compare them don't forget that with CDO you do not need any .dlls, classes, APIs, etc. Not even Outlook (so no Redemtion or click-yes required) or indeed any email client at all. Plus it can be sent easily using VBA code from within a module. All you need is the address of a domain that you can send email through. I will post a complete CDO package here soon. I am currently updating my EATBloat program with a complete overhaul and including the options to output individual objects and import them as well, plus some other features. Regards Max -----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 6:59 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Need SMTP Code Dang! My cup runneth over. I'll check into this. Thanks. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of ACTEBS Sent: Sunday, August 05, 2007 10:28 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Need SMTP Code Rocky, The easiest and feature rich method I have found useful is by using Blat. You can find it here: http://www.blat.net/ It even has an Access Class you can use already written: http://www.blat.net/examples/MSAccess_class.html Distribute Blat with your application and you won't need to worry about those annoying MS messages anymore. HTH Vlad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Monday, 6 August 2007 1: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 -- 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