Problem import/export contacts w/ Excel

F

Fred Criswell

I exported my Outlook contacts into Excel so that it would automatically
generate the header row, then I cut and pasted contact information from
several different Excel spreadsheets. When I tried to import the information
back into Outlook, it only imported the first 100 (approx) out of 600+
entries. There is no error message - it appears not to read the 'cut and
pasted' entries.

Any advice would be appreciated.
 
S

Sue Mosher [MVP-Outlook]

Did you expand the named range to include the additional rows?
 
K

Karl Timmermans

Make sure that your entire area that you want to import back is contained
within one named range including the first row which contains the
field(column) names. When you import the data - use that named range.

Karl

--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com
 
Top