[AccessD] modifying Outlook contact items from Access

Susan Harkins ssharkins at bellsouth.net
Thu Jan 22 15:18:29 CST 2004


Thanks Marty -- first one's too complicated. The second doesn't work because
Outlook isn't the default mail client -- if Outlook was the default mail
client, you could just link and skip the code altogether. ;( Seems like the
second ought to work, I'm just missing something.

Susan H.


> 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/_ex
ch2k_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
>
>
>
> _______________________________________________
> 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