[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

email address field not shown in linked table in ms access

I am trying to import contacts from my public folder in exchange to access 2007 which is working, however it does not populate the email field.

however if i do the same using my personal outlook address book, the email field shows up properly.

any help

1 Solution
Helen FeddemaCommented:
Lots of fields are left out when you link an Outlook folder as a table in Access.  I recommend using VBA Automation code instead, because not only can you work with all the standard fields, but custom fields as well.  Here is a link to a code sample database with code to import contacts into an Access table:


It is rather old, but should work with Office 2007.  For more updated code, see my Access 2007 Bible book.
junaidITAuthor Commented:
this is definitely a good thing to start with .

thanks for the help

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now