[AccessD] Send Email Automatically VB6

Hi Paul

You have one of 2 options besides MAPI, dependant on your environment. With
Windows Active Directory and Exchange 2000 you can use ADSI, otherwise you
have CDO (Collaborative Data Objects). Either way there are articles on
MSDN, though in general ADSI is less well documented as people haven't been
using it long.

As to whether they are 'better' than MAPI, I don't know on account of not
having used them. If you have a go, I'd love to hear how you get on.

Roz

-----Original Message-----
From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] 
Sent: 04 July 2003 10:18
To: accessd at databaseadvisors.com; dba-vb at databaseadvisors.com
Subject: [AccessD] 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.


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