[AccessD] modifying Outlook contact items from Access

Have you looked here... http://www.slipstick.com/dev/database.htm

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 Susan Harkins
Sent: Friday, January 23, 2004 10:31 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] modifying Outlook contact items from Access


Yes, you can link to Outlook from Access 2000 -- well, I'm sure you can with
Access k2 -- but Outlook has to be the default mail client -- which is the
problem. So, I need code -- and I was hoping there was a way to directly
link to the data via an ADO object or something -- but I haven't been able
to make it work. So, I can import it, change it, and send it back -- but so
far, sending it back hasn't actually updated it in Outlook.

Susan H.


> Um, setup a linked table to an Outlook/Exchange Folder?  What version 
> of Access.  It's there by default for A2k (and I would assume later
> versions...) but in 97, you have to download a free Add-in from 
> Microsoft.
>
> Drew
>
> -----Original Message-----
> From: Susan Harkins [mailto:ssharkins at bellsouth.net]
> Sent: Thursday, January 22, 2004 12:34 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] modifying Outlook contact items from Access
>
>
> 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 
> _______________________________________________
> 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