MartyConnelly
martyconnelly at shaw.ca
Thu Jan 22 14:04:27 CST 2004
There is an Exchange OLEDB Provider available for those that use it. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/_exch2k_search_tasks.asp And this method might work This article describes how you can open a connection to a Microsoft Exchange or to a Microsoft Outlook mailbox by using ActiveX Data Objects (ADO) and the Jet OLE DB provider http://support.microsoft.com/?kbid=275262 Susan Harkins wrote: >This is for instructional purposes, so I have to do it the long hard way. :) > >I can import the data into Access, modify it, and send it back to Outlook. >I'm just wondering if there isn't a more direct route -- it would be cool if >I could connect an Access form's to a recordset that's connected directly to >Outlook -- so the changes in Access would be immediate -- I just don't know >if that's possible, or even the best way to go about it. > >Susan H. > > > > >>Hi Susan >>Well I cheat. I have a number of Outlook address books some of which are >>based on Access data. I use a 3rd-party product which each night wipes out >>these address books, extracts the Access data and rebuilds the address >>books. Works like a charm. I could no doubt write something but as the >>product existed..... See http://www.teamscope.com/otherpro/datalink.asp >> >> >>Andy Lacey >>http://www.minstersystems.co.uk >> >> >> >>>-----Original Message----- >>>From: accessd-bounces at databaseadvisors.com >>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of >>>Susan Harkins >>>Sent: 22 January 2004 17:26 >>>To: AccessD at databaseadvisors.com >>>Subject: [AccessD] modifying Outlook contact items from Access >>> >>> >>>I'm familiar enough with the Outlook model that importing >>>Contact data into Access is easy -- but I'm wondering if any >>>of you use Access to actually modify Outlook contact >>>information? I haven't even started, but would be interested >>>in hearing how others do it. I know you can link, but that >>>only works if Outlook is the default mail client. >>> >>>Susan H. >>> >>>_______________________________________________ >>>AccessD mailing list >>>AccessD at databaseadvisors.com >>>http://databaseadvisors.com/mailman/listinfo/a> ccessd >>>Website: >>>http://www.databaseadvisors.com >>> >>> >>> >>> >>_______________________________________________ >>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 > > > -- Marty Connelly Victoria, B.C. Canada