import from Excell or Word into Outlook

[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..?

 

[Karl Timmermans]

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

 

[Russ Valentine [MVP-Outlook]]

File > Import and Export will show you a list of file formats from which
Outlook can import. Excel and CSV are among them.

 

[Martin]

Thank you very much