import from Excel

  • Thread starter Thread starter Can I import to outlook from excel
  • Start date Start date
C

Can I import to outlook from excel

Can I, and if so how, Import an address book from/created in excel 2007 to my
outlook address/ and or contacts ?
Thank-you,
Rick
 
File > Import and Export...

--
Russ Valentine
[MVP-Outlook]
"Can I import to outlook from excel" <Can I import to outlook from
(e-mail address removed)> wrote in message
news:[email protected]...
 
"Can I import to outlook from excel" <Can I import to outlook from
(e-mail address removed)> wrote in message
Can I, and if so how, Import an address book from/created in excel 2007 to
my
outlook address/ and or contacts ?
Thank-you,
Rick
Click to expand...


In addition to what Russ posted - create a new contact in Outlook, and
export that to Excel. Check that your created Excel addressbook fields match
the Outlook ones. then in Excel name the range of data before you try the
import.
 
Would suggest that anyone who is importing any data into Outlook, regardless
of input file type, <ALWAYS> go through the "Map Custom Fields" step
whether or not the column names match those of Outlook. Getting used to
letting Outlook "auto-map" field names (which basically is the only benefit
to changing column names) without manually checking the mapping, can easily
lead to problems (missed fields because of column name not changed correctly
etc). Also, by going through that step, it negates the need to rename column
headers altogether.

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 
Karl Timmermans said:
Would suggest that anyone who is importing any data into Outlook,
regardless of input file type, <ALWAYS> go through the "Map Custom
Fields" step
Click to expand...

true - but that process can be quite un-intuitive if you are not familiar
with it.
 
Back
Top