[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
>