[AccessD] Email problem. Again

Rocky Smolin rockysmolin at bchacc.com
Mon Mar 1 16:31:46 CST 2010


"It was left out from Vista and Win 7."  Does that mean that if he's trying
to send emails and using Vista, it won't work?

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Monday, March 01, 2010 1:45 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Email problem. Again

Hi Jim

> ..you need to know the SMTP server,
> you need and account and password, and you need to know how it wants 
> to authenticate.

But if you, as a service, host your own SMTP server you can more or less
hardcode a set of standard user credentials in the client. That leaves only
one problem: An open port 25. Even that can be circumvented if you run your
dedicated SMTP server off-standard at port 80 which practically always is
open for web browsing. And an SMTP is no big deal; it was a standard service
from Win NT to Win XP/2003/2008. It was left out from Vista and Win 7.

> Haven't used IPWorks, but I believe it's Gustav that likes it a lot.

Nope, sorry, don't know anything about IPworks except for its incredible
price tag!

/gustav


>>> jimdettman at verizon.net 01-03-2010 20:38 >>>
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


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list