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 / July 2005

Tip: Looking for answers? Try searching our database.

Prepare a spreadsheet in Excel to export to Contacts in Outlook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Anna - 20 Jul 2005 15:58 GMT
Hi! How do I prepare an Excel spreadsheet so I can import it into a Contacts
folder in Outlook? Thanks!
Noel All - 20 Jul 2005 16:02 GMT
I find that if you export your Contacts first to Excel then this can act as
a template for your own sheet
> Hi! How do I prepare an Excel spreadsheet so I can import it into a
> Contacts
> folder in Outlook? Thanks!
Karl Timmermans - 20 Jul 2005 18:08 GMT
Process is really simple:

Row#1 - Header Row. Each column contains the name of the field you want to
import (i.e. FullName, CompanyName etc). These names do not have to be
identical to those used by Outlook.

Rows2 thru x - contains the actual data for the contacts you want to import
with the "content" of each column matching what you set up in Row #1

Make sure you create a named range that covers the <row/columns> in BOTH the
header row and all detail rows the follow it. Info on how to create a named
range can be found in the Excel help file.

Import file into Outlook and manually map each field from your Excel sheet
to the appropriate Outlook field.

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

> Hi! How do I prepare an Excel spreadsheet so I can import it into a
> Contacts
> folder in Outlook? Thanks!
 
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.