Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / February 2004

Tip: Looking for answers? Try searching our database.

import from Excell or Word into Outlook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Martin - 28 Feb 2004 19:11 GMT
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 - 28 Feb 2004 20:00 GMT
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

Signature

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

> 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..?
Russ Valentine [MVP-Outlook] - 28 Feb 2004 20:06 GMT
File > Import and Export will show you a list of file formats from which
Outlook can import. Excel and CSV are among them.

Signature

Russ Valentine
[MVP-Outlook]

> 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..?
Martin - 29 Feb 2004 15:22 GMT
Thank you very much

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.