[AccessD] Need SMTP Code

No need to fork out for Wise. Use the freeware Inno Setup and it'll take
care of all for you:

http://www.jrsoftware.org/isdl.php

Absolutely awesome tool and best setup scripting tool I've used.

Vlad

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: Tuesday, 7 August 2007 1:02 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Need SMTP Code

FYI: with a Wise installation you can include and register dlls.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Monday, August 06, 2007 8: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


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