Doug Murphy
dw-murphy at cox.net
Fri Sep 25 19:00:13 CDT 2009
Hello Gustav, Thank you for the excellent information. I tried my ISP smtp server again and it worked this time. I must have had something set incorrectly the last time I attempted using CDO from Access. Asside from the GMAIL cops shutting me down once their server has been relaiable. Once I explained that I was sending notices to a list of members they unlocked my account for the organization. I tried using the SMTP server for one of our hosting accounts but my connection was not successfull. I have little knowledge of SMTP so was not able to figure out if it was my connection parameters causing the failure or they were blocking me. I can get to the server from my web site. Thanks again. Hopefully I'll learn something here. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Friday, September 25, 2009 3:23 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Automated emails from Access requiring validation foreach email Hi Doug Several methods: 1. Use a small client that communicates directly with the receiving SMTP server. Only for low volume mail and/or in a closed circuit where receivers are known and reliable. Your app must handle transmission errors. 2. Use the "Smart Host" - the SMTP server of the current ISP. Will most often not need authentication. Great for mails sent to multiple users. This is the most common method. 3. Provide your own SMTP server (hosted or in-house) for the clients. If so, your server must accept connections from outside which means that authentication is a must. Is not possible for clients where port 25 is blocked except if you use secure connections to your server. Gives you access to logs for the traffic. 4. Use Gmail SMTP as you have explained below. A variation of #2 and #3 above. 5. Use an SMTP at, say, a web hosting company. These always have an SMTP server for sending mail from web apps, and sometimes this allows normal mail from clients. Will always require authentication. We use all methods. The choice is dependant on the purpose. No method is "best". /gustav >>> dw-murphy at cox.net 25-09-2009 19:51 >>> Possibly I can get educated here re SMTP. I use CDO via Access to send email to eliminate the Outlook issues. The issue I have found is that most non-business plans through an ISP block the regularly used SMTP ports. Mine does. The only way I have been able to get around this is to use the GMAIL SMTP server on their secured ports which give you access with your Gmail credentials. The risk here is that if you send many messages at one time, less than 100 in my case, and have bounces or rejections Gmail may shut down your account. How do list users handle situations where you don't have access to corporate servers? Doug -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com