[AccessD] Need SMTP Code

Dan Waters dwaters at usinternet.com
Mon Aug 6 09:18:14 CDT 2007


Rocky,

Users don't need to know anything.  In fact, the email will go out without
even telling them anything happened, unless you put up a dialog box to tell
them!

But in the BE somewhere you need to store the SMTP Server Name - every
company has their own.  IT will know what it is, and you may want to set up
a form for them to change it as needed.  In the SMTP code module, you'll
need to recall that SMTP Server Name, and set a property for the vbSendMail
object.

By tomorrow, I will post generic code showing how I've set up my SMTP code
module.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Monday, August 06, 2007 8:59 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Need SMTP Code

Dan:

Sterling endorsement. :)  Looks like a good candidate. Simplest for the end
user is best.  With vbSendMail does the user have to know their server name,
port, etc.?  The less stuff they have to know the better.

Thanks

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Monday, August 06, 2007 6:17 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Need SMTP Code

Rocky, 

I've used vbSendMail for several years also, and it works well.  Also has a
great user manual.  I've incorporated the code into a single module in my
Access apps.  The one thing I would like to do but not sure how is to write
a class that detects and reports SMTP errors (Access can't do this).  The
Let and Get properties are already there, I'm just don't know how to use
them.  Of course, the manual's author says it's easy.

You do need error trapping in your app that can detect if the .dll file is
not present, so the IT folks at your client can install and register the
files (they tend to forget to install them with a replacement PC).  You'll
get 429 and 91 errors if it's not there.  Other than this, I've had no other
errors.

It's at http://www.freevbcode.com/ShowCode.Asp?ID=109 and is called
vbSendMail.

HTH!
Dan Waters

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Monday, August 06, 2007 7:54 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Need SMTP Code

Rocky,

  I'm not sure "better" would be the correct word, but I do find it simpler.
I need only one .DLL to be registered to make the code work.

  BLAT is even simpler yet, but unless you use the DLL version, you have no
error checking or real control over it.  And last I checked, the .DLL
version was lacking several key features and was a rev or two behind the
command line interface.

  CDO has come along way.  Early on there were multiple versions and they
all didn't work the same.  I've been quite happy with the direct SMTP code
I've been using and have not needed to develop anything more sophisticated,
so I have not taken another look at CDO in a long time. 

  I believe that you still need to rely on it being installed and it only
comes with certain Microsoft products.  There is no separate download that
I'm aware of.

  This is another reason I've not used it as I like to provide my apps with
everything that's required and not rely on external products if at all
possible.

  But it certainly has a lot more capabilities then sending e-mail and it
may be worth starting down that road to get a handle on it for the future.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Sunday, August 05, 2007 11:44 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Need SMTP Code

Thanks.  Looks easy enough.  Is it better than the CDO approach? 

Rocky



 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Sunday, August 05, 2007 7:28 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Need SMTP Code

Rocky,

  see:

http://www.freevbcode.com/ShowCode.Asp?ID=109

 works well with Access.  Have used it for years.  Only requires one .DLL

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Saturday, August 04, 2007 9:10 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Need SMTP Code

Dear List:


I have a lot of Access sites bookmarked but can never find what I need in
them.  I'm looking for some code to handle email from Access using SMTP.
Does anyone know if there's a module I can crib from one of the many Access
sites?

MTIA

Rocky

--
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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.11.4/936 - Release Date: 8/4/2007
2:42 PM
 

--
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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007
4:16 PM
 

-- 
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