[AccessD] Exchange server

I believe you can do it by opening a MAPI session on the server via VBA.

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


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Wednesday, June 11, 2003 1:39 PM
To: AccessD
Subject: [AccessD] Exchange server


My client uses Exchange server.

I currently have Outlook running on an employee's workstation, and he
receives emails form their client with attachments which have to be
processed by the database.  On this employee's machine I have a rule in
Outlook that moves all emails from their client with a specific subject into
a subfolder in Outlook.

I then have an instance of Outlook running in the database (Withevents). The
database thus gets an event anytime an email comes into that subdirectory.
The event sink grabs every message in the subfolder and saves the
attachments into a working directory on the server, then copies the email
into a sub-sub folder so it isn't processed again.  The attachements are two
text files and an excel spreadsheet.  The text files are imported using an
import spec, and the spreadsheet is imported using append queries, linking
the spreadsheet to a known name.

This all works very well.

However we are moving this kind of process onto a server where it will run
continuously.  We will no longer have to worry about keeping his workstation
turned on, power failures, his going on vacation etc.

The client has asked me if he needs to have Outlook running on the server or
if I can pull the emails out of Exchange Server directly.

Can I?

John W. Colby
www.colbyconsulting.com


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