Max Wanadoo
max.wanadoo at gmail.com
Mon Mar 1 14:24:10 CST 2010
Why is that a problem. Google lets you have as many as you want. Rocky.client1name at goolemail.com Rocky.client2name at goolemail.com Rocky.client3name at goolemail.com You can even take out a business solution from them with Google docs etc, etc. Google gives you tons of stuff that MS does not. Etc. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 01 March 2010 20:17 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Email problem. Again Yeah, but it's not for me - it's for a client and then he's going to try to resell the app to others. So it has to be pretty general case. r -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Monday, March 01, 2010 11:43 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Email problem. Again Well, you could always open a Gmail account with Google called Rocky.Clients at googlemail.com and then use their smtp to send out your client emails. You could also use it to handle their emails to you. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: 01 March 2010 19:38 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Email problem. Again Dan, I've used the vbSendMail.DLL for many years, but Rocky will still have the same issues that he has with CDO; that is you need to know the SMTP server, you need and account and password, and you need to know how it wants to authenticate. vbSendMail does have some code to support finding the SMTP server via the DNS MX record, but it still won't help if you don't have an account to authenticate with nor know how the server wants to. Unfortunately, the days of open SMTP servers that will accept mail from anyone are gone. The only issue with CDO is that there are different CDO libs, but most of those have retired by now (NT4 was different then 2000, etc). Other then that, it's similar to vbSendMail in terms of functionality. However you are relying on something being installed on the client as you would be with Outlook. Like you, I've found vbSendMail easy to use and it works as a drop in even though it reads as VB 6.0. I even wrote a class wrapper for it because it had too many options for most of what I do with mail, which worked fine. Haven't used IPWorks, but I believe it's Gustav that likes it a lot. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Monday, March 01, 2010 1:25 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Email problem. Again Hi Rocky, Go to http://www.freevbcode.com/ShowCode.Asp?ID=109 to download this application and .dll. This includes an application form where you can enter all your info and send an email. After you register the files vbSendMail.dll and mswinsck.ocx, and then the email doesn't go, then it's a network issue. I've also converted this to use with Access, and it's completely reliable. Good luck! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Monday, March 01, 2010 10:32 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Email problem. Again Dear List: Couple years ago I got a lead here on how to automatically send emails with reports attached from an app for one of my clients client - a patent attorney who needs to send regular reports to all his clients. I ended up with a routine I got from a link called SendSMTPMail which requires a reference to Microsoft CDO for Windows 2000 library. It requires that you pass to the routine the mail server name, user name, password, and port. And it worked for many months. Then it stopped. It works on my machine with my personal but at their site, where they're using Exchange server, something may have changed. Who knows? We had a session with their network guy but couldn't get it to work. OTOH, I had the client try the routine at home on his laptop using his personal account and he reported that it failed. Now I don't know for sure what parameters he passed to the SendSMTPMail routine so I don't know if they were the right ones. But if he has the right ones, and it failed on his personal account, then that might point to the CDO? But that's been the same (AFAIK) since day 1. In any event, 2 questions: 1) any ideas why this would stop working? 2) is there a more "moderne" approach to this sending of emails? He and I discussed using the Outlook object - I've got that code in other apps, but since he has ambitions to resell this system to other law firms, it should be independent of Outlook. MTIA Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/> -- 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 -- 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