[AccessD] email from outlook

Stuart, 

I use a framework.  The framework (for example) has an error log which logs
program errors, both framework and application.  I need a way to email these
error logs out to the dba, either on a critical (application) error or
"every day" etc.  Of course I can set up the framework for the environment
that I am currently working in, however I am trying to make this
"automatic", so that anyone trying to use the framework (other developers)
can just drop it in and go.  I do not want the developer to have to
"configure" the framework in order to get email sent out.  They should just
be able to call a send method of the framework and know that the mail will
be delivered.

On a similar note (but not email) I have for a long time wanted to be able
to have my programs automatically "call home" over the internet, similar to
Norton AV which looks for AV updates automatically.  This would be handy for
notifying the user that there was a newer version of the program (or
framework), uploading or downloading data etc.  I know absolutely nothing
about how to do that unfortunately, but if anyone out there does, I would
love to see a discussion started.

John W. Colby
Colby Consulting
www.ColbyConsulting.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Sunday, June 18, 2006 9:14 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] email from outlook

On 18 Jun 2006 at 20:08, JWColby wrote:

> I know this has gone around many times and I hang my head in shame to 
> even ask again, but is there a "no brainer, no nonsense" way to send 
> email from VBA code, that will just work, without needing to have any 
> specific email client installed.
> 

It depends.

Do you want it to send through an email client?
That gives you the opportunity to save a proper "Copy To Self" or "Sent
Mail" copy for reference purposes. It also allows you to have an option to
"Edit before sending" if the email is createdby a user  rather than an
automated process.  It also sometimes requires the email client to be
already running on the clinet machine (especially if the client is Outlook
and you have multiple profiles set up. 

Do you  want it sent  direct to an SMTP Server?
This doesn't work if the you are on a corporate LAN where users only have
email access through something like Exchnage Server with no SMTP module
active.

What is your actualy requirement?





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