Stuart McLachlan
stuart at lexacorp.com.pg
Mon Mar 1 16:46:12 CST 2010
In which case, they need an in-house mail server. If they are using an in-house mail server, you just need to store the IP address of the server. There are plenty of good low-cost mail servers out there that are simple to set up and maintain. -- Stuart On 1 Mar 2010 at 12:38, Rocky Smolin wrote: > Law firm - they want copies of all emails coming and going and they want it > in-house. > > 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 12:24 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Email problem. Again > > 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 > > -- > 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