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 / January 2006

Tip: Looking for answers? Try searching our database.

IMPORT ADDITIONAL DATA FROM EXCEL TO OUTLOOK CONTACTS

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
greek evangelos - 08 Jan 2006 00:43 GMT
I wanted to add new contacts at my outlook so i exported the contacts to an
excel file. Then i added new data in each field and tried to import them back
to outlook.
The new data does not show up.
Karl Timmermans - 08 Jan 2006 04:23 GMT
When you export contacts in Outlook to Excel - a <named range> is created
which is identical to the worksheet name which is the same as the Outlook
folder name you exported. The <Named Range> will only include the rows
exported by Outlook. When you added new contacts (which is what I assume you
mean by adding new data in each field) - this does not change the <Named
Range> boundries. All you need to do is change the ending row/col of the
<Named Range> to reflect the number of rows you've added.

In case you're not familiar on how to change the <Named Range> - from your
menn in Excel just go to:
  --> Insert
           --> Name
                    --> Define

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

>I wanted to add new contacts at my outlook so i exported the contacts to an
> excel file. Then i added new data in each field and tried to import them
> back
> to outlook.
> The new data does not show up.
 
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



©2009 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.