Outlook Contacts to Access

[pjk]

trying to import outlook contacts into Access - done that using
addfromOutlook command - but this does not include the 'category' field in
Outlook and I want to bring that field over into Access and export from
Access to Outlook.

is this possible and if so can someone tell me how to modify the command.

thanks

 

[Arvin Meyer [MVP]]

Have you tried exporting from Outlook? Sometimes you may need to export as a
CSV or TXT file, then import that file into Access.

 

[pjk]

i was trying to avoid the export/import mode and just link - so the data can
be updated automatically. since the outlook contact - name, email etc can be
linked thought it would be easy to just add the 'category' field to the same
link but cannot locate the code to add it. i got the 'outlook command' code
from a database template i downloaded from microsoft site.

 

[Arvin Meyer [MVP]]

There is no direct linking between Access and Outlook, at least that I know
of. At least until Outlook 2002 (and maybe later), it was possible to store
an Outlook EntryID in Access and write from Outlook to Access in response to
events in Outlook. The EntryID only works from an MS-Exchange mail server
and is a 128 character GUID string.

I've written code for Outlook to Access syncing for Outlook 2000/2002, but
we eventually abandoned it. Too many users have access to Outlook and it is
difficult to maintain validation of data (duplicates, spelling, deletions,
etc.) Outlook users would delete a contractor from their address book and it
would delete the entry in Access. There was so much screwed up data (2/3rds
of it) that we eventually found that it was much faster to just maintain
them separately.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com