import from Excell or Word into Outlook

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hi,

I wonder if it is possible to create new contacts for
Outlook using properly formatted data from a word or
excel document. The opposite is possible with mail merge
but is this feasable too..?
 
Process is extremely simple and easy to do as long as you follow these
rules:

#1 - If using Word - make sure you save the file as a "text file" delimiting
each column with either a "," or a tab. Just one note of caution - if any of
your fields already contain commas then you would have to properly format it
as a CSV file adding appropriate quotes where applicable so a tab delimitor
would probably be your safest bet in this scenario
#2 - Make sure the first line/row contains the column names for every field
you want to import
#3 - For Word - make sure you have the additional delimitors for any empty
fields in the row otherwise the import will fail or
get messed up
#4 - For Excel - make sure you have a correct "named range" for the data you
want to import OR if you're not familiar with
"named ranges" - simply save the Excel worksheet as a CSV file.
#5 - Just import whatever file you created using the Outlook import/export
wizard selecting the appropriate file type.

Karl

--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://contactgenie.claxton.com
 
File > Import and Export will show you a list of file formats from which
Outlook can import. Excel and CSV are among them.
 
Back
Top