[AccessD] Send Email Automatically VB6

Paul,

  I'm dropping some code to you off list that sends e-mail directly to the
SMTP server.  This avoids worrying about what client is installed on the
machine.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-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: [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