[AccessD] Exchange server

Charlotte Foust cfoust at infostatsystems.com
Wed Jun 11 16:15:29 CDT 2003


Collaborative Data Objects, it's a programming wrapper over MAPI.

Charlotte Foust

-----Original Message-----
From: John Colby [mailto:jcolby at colbyconsulting.com] 
Sent: Wednesday, June 11, 2003 12:54 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Exchange server


what is cdo?

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Joe Rojas
Sent: Wednesday, June 11, 2003 2:13 PM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Exchange server


Mind you that I don't have a code example but this code be achieved by
using CDO instead of Outlook.

Joe R.

-----Original Message-----
From: John Colby [mailto:jcolby at colbyconsulting.com]
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



This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please
notify the sender as soon as possible and destroy this message. While
TNCO, Inc. uses virus protection, the recipient should check this email
and any attachments for the presence of viruses. TNCO, Inc. accepts no
liability for any damage caused by any virus transmitted by this email.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



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


More information about the AccessD mailing list