Contact Import from Outlook folder - Many columns are missing

Copper Contributor

When I import outlook contact from access import option many main columns are missing. How to get all columns are get missing few columns?

 

Step 1: Saved only 15 contacts in outlook local from my office global address list

Step 2: Exported those 15 contacts to excel using outlook export option... Now saved excel is having 93 columns

Step 3: Now import those 15 contacts from access using option import from outlook folder. Now imported table is having only 30 columns. 

 

Question is I am not looking all 93 columns if outlook import all columns also fine. But main 1 or 2 columns are missing. I am not finding option to select missing important columns also. 

 

Looking for someone quick response on this.

1 Reply
Use VBA and you'll have access to everything.