[dba-VB] Send Email Automatically VB6

Working with the Outlook object model would be the easiest.  The only
problem with it is that when Microsoft tightened the Security on Outlook
they added message boxes to alert the user when another program was trying
to send a message through Outlook.

To get around the Outlook Security patch issues, you have 2 choices:  
1.  Redemption (http://www.dimastr.com/redemption/)
2.  MAPI/CDO code

You can get more information on your options by looking at the following
sites...

Slipstick Systems Outlook and Exchange Solutions Center
http://www.slipstick.com/
Outlook CDO Knowledge Base http://www.microeye.com/resources/res_outlkb.htm
CDO Live http://www.cdolive.com/cdo5.htm

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: Friday, July 04, 2003 5:18 AM
To: accessd at databaseadvisors.com; dba-vb at databaseadvisors.com
Subject: [dba-VB] Send Email Automatically VB6


To all,

First things first, the FE is VB6 the BE is SQL Server 7.0, using Windows XP
Professional with Outlook as my default Email.

I have a table of users on which contains Username, Password, AccessLevel,
JobTitle_Or_Department.  What I need to do is on certain sections of my
application is run down the list of users and based on their job title or
department, add them to the TO section of the email, then add any IT
Developer (Job Title) to the CC section of the email.  I also need in some
cases to be able to add an attachment to the email.

What is the best way to go about this, I was going to use MAPI but just
wondered if anyone out there knew a better way.

Thanks in advance.

Paul 

__________________________________________________________________________
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for Best
Unmetered ISP and Best Consumer Application.


_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com