Drew Wutka
DWUTKA at marlow.com
Wed Jun 11 16:21:07 CDT 2003
CDO ( I believe Collaboration Data Objects) is actually the backbone of MAPI. Drew -----Original Message----- From: John Colby [mailto:jcolby at colbyconsulting.com] Sent: Wednesday, June 11, 2003 3: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