Contact Import from Outlook folder - Many columns are missing

%3CLINGO-SUB%20id%3D%22lingo-sub-1651851%22%20slang%3D%22en-US%22%3EContact%20Import%20from%20Outlook%20folder%20-%20Many%20columns%20are%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1651851%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20import%20outlook%20contact%20from%20access%20import%20option%20many%20main%20columns%20are%20missing.%20How%20to%20get%20all%20columns%20are%20get%20missing%20few%20columns%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStep%201%3A%20Saved%20only%2015%20contacts%20in%20outlook%20local%20from%20my%20office%20global%20address%20list%3C%2FP%3E%3CP%3EStep%202%3A%20Exported%20those%2015%20contacts%20to%20excel%20using%20outlook%20export%20option...%20Now%20saved%20excel%20is%20having%2093%20columns%3C%2FP%3E%3CP%3EStep%203%3A%20Now%20import%20those%2015%20contacts%20from%20access%20using%20option%20import%20from%20outlook%20folder.%20Now%20imported%20table%20is%20having%20only%2030%20columns.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuestion%20is%20I%20am%20not%20looking%20all%2093%20columns%20if%20outlook%20import%20all%20columns%20also%20fine.%20But%20main%201%20or%202%20columns%20are%20missing.%20I%20am%20not%20finding%20option%20to%20select%20missing%20important%20columns%20also.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20for%20someone%20quick%20response%20on%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1651851%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.