A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

export contacts to excel add then import



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old April 14th 07, 11:26 PM posted to microsoft.public.outlook.contacts
Henry Roif
external usenet poster
 
Posts: 6
Default export contacts to excel add then import

Let me ask a qustion with an example
I hace 5 contacts in Outlook - Export them to Excel -
I add 1 Contact in the Spreadsheet
then reimport it back to Outlook.
I was expecting the new contact to appear in Outlook, but it didnt happen.
On the Other hand I DELETED a contact from the Excel spreadsheet; but whe I
Imported it back the contact was STILL THERE.......

hroif
Thanks

Ads
  #2  
Old April 15th 07, 02:34 AM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 789
Default export contacts to excel add then import

Adding a contact to Excel etc

Make sure you change the named range to include all of your contacts instead
of the original group of 5. The export process will create a "named range"
for the items exported. If you added a row at the end of the list - won't be
included automatically.

Contact still there after deleting from Excel?

You wrote "was STILL THERE..." - there = where exactly?. If referring to
contact folder, will always be there unless you delete it from the contact
folder. Importing via the Outlook import wizard is only going to add the
contacts.

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



"Henry Roif" wrote in message
...
Let me ask a qustion with an example
I hace 5 contacts in Outlook - Export them to Excel -
I add 1 Contact in the Spreadsheet
then reimport it back to Outlook.
I was expecting the new contact to appear in Outlook, but it didnt happen.
On the Other hand I DELETED a contact from the Excel spreadsheet; but whe
I
Imported it back the contact was STILL THERE.......

hroif
Thanks



  #3  
Old April 15th 07, 11:08 AM posted to microsoft.public.outlook.contacts
Henry Roif
external usenet poster
 
Posts: 6
Default export contacts to excel add then import

Karl.
Thank You for your answer.
I will recheck before asking again.
Henry

"Karl Timmermans" wrote:

Adding a contact to Excel etc

Make sure you change the named range to include all of your contacts instead
of the original group of 5. The export process will create a "named range"
for the items exported. If you added a row at the end of the list - won't be
included automatically.

Contact still there after deleting from Excel?

You wrote "was STILL THERE..." - there = where exactly?. If referring to
contact folder, will always be there unless you delete it from the contact
folder. Importing via the Outlook import wizard is only going to add the
contacts.

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



"Henry Roif" wrote in message
...
Let me ask a qustion with an example
I hace 5 contacts in Outlook - Export them to Excel -
I add 1 Contact in the Spreadsheet
then reimport it back to Outlook.
I was expecting the new contact to appear in Outlook, but it didnt happen.
On the Other hand I DELETED a contact from the Excel spreadsheet; but whe
I
Imported it back the contact was STILL THERE.......

hroif
Thanks




 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How export contacts to excel add contact and import again Henry Roif Outlook - Using Contacts 2 April 17th 07 04:12 PM
Export contacts to Excel Gareth Outlook - Using Contacts 4 February 26th 07 06:23 PM
Why can't I export outlook contacts to Excel/Access, etc? Pat Outlook - Using Contacts 2 January 16th 07 11:04 PM
Export contacts to Excel. LisaD Outlook - Using Contacts 1 August 22nd 06 06:43 PM
Export Excel to Outlook Contacts Kerri Outlook - Using Contacts 1 March 8th 06 08:43 PM


All times are GMT +1. The time now is 03:39 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.