Link Outlook to Microsoft Access

[Guest]

I imported a Table from an Access Database into a Contacts Folder in Outlook.
This imported an ID number into Outlook that matches the Access ID Number.
When I create a linked table in Access for the Outlook Contacts, I cannot get
the ID number to show in the linked table. I need the ID Number to be in the
Linked Table with the Number format in order to query the Linked Table and
the Original Access Table.

Also, is ther any way to change the 4 User Fields. Can the Names of these
fields be changed? Can the Type be changed from text to a Number Format.

Any suggestions

Regards,
Bill

 

[Sue Mosher [MVP-Outlook]]

The linked table method has major limitations, including the inability to show even all the reasonably important fields, much less custom fields. While articles have been written on how to expand on this method's obvious features, I've never been able to duplicate the results. See http://www.outlookcode.com/article.aspx?ID=25 .

That page will also give you other ideas on how to work with databases and Outlook together. You'll need to write code or use a third-party tool that does the heavy lifting.

It is not possible to change the name or data type of any standard Outlook property.

 

[Guest]

Thanks for the response. This is not what I wanted to hear. I will look at
the web site you provided and post a response. There must be a Number Format
Field that can be used when creating the Link to OUTLOOK in ACCESS, even if
the name of the field has to remain unchanged.(ie. Not match the field name
in access). I could use one of the 4 User defined fields but they are text
fields.