Dan Waters
dwaters at usinternet.com
Thu Dec 18 09:18:24 CST 2003
Thanks to Erwin, Francisco, and Paul! Now I have two more (and better) options to explore. Dan Waters Quality Process Solutions -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of paul.hartland at fsmail.net Sent: Thursday, December 18, 2003 3:07 AM To: Access Developers discussion and problem solving Subject: Re: RE: [AccessD] Route email to SMTP Server from Access Have you looked at vbSendMail it's free to download. It sends email straight to the SMTP server and works in VB6 like a charm. I'm sure it can be used in Access (may be worth looking into) Paul Hartland Message date : Dec 17 2003, 08:50 PM >From : Erwin Craps - IT Helps To : Access Developers discussion and problem solving Copy to : Subject : RE: [AccessD] Route email to SMTP Server from Access You could consider buying some ActiveX controls that do the job for you. I bought several years ago the ip works kit for VB/VBA. They have SMTP/MIME conrols etc... Using an SMTP server directly does mean more work. For example if you would need to add attachements then you need to mime this. Further more you can run into firewall problems at customer site.. Erwin -----Oorspronkelijk bericht----- Van: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] Namens Dan Waters Verzonden: woensdag 17 december 2003 20:55 Aan: Database Advisors Onderwerp: [AccessD] Route email to SMTP Server from Access Hello and Happy Holidays to everyone! I have a customer I am getting started with. To send email and get around the Outlook security patch, I suggested either using Redemption or using the Outlook Security Administrator's package. I then received the suggestion to try sending email straight to the SMTP server, bypassing the security problem. What seems to be required to do this is to either use CDO, of which there are different versions (CDO, CDONTS, and CDOSYS), or a 3rd party product. Is this really correct or is there another way? Perhaps a Windows API that can be used for the same purpose? I did do a search on the archives for SMTP, but because many people's emails have SMTP in the email header, the search was not useful. Anyone have an early Christmas present they can give me? Thanks! Dan Waters Quality Process Solutions. _______________________________________________ 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 Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month www.freeserve.com/anytime _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com