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

Importing Excel without losing most of the contact data



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old December 20th 07, 03:27 PM posted to microsoft.public.outlook.contacts
Bob
external usenet poster
 
Posts: 161
Default Importing Excel without losing most of the contact data

I am using Excel 2003. I am trying to import an Excel csv file (containing
contacts) into Outlook 2003. From there I will export it to a website
that will maintain these contacts for me and allow me access. I am following
their instructions:

In order to preserve all the contact information I want before exporting to
the website, I must import into Outlook with the column headers adjusted on
the spreadsheet. However, when I adjust the headers and go to save the file I
get the following message:

[file] may contain features that are not compatable with csv (comma
delimited). Do you want to keep the workbook in this format? To keep this
format which leaves out incompatible features, click Yes. To preserve the
format, click No and then save in the latest Excel format. To see what might
be lost, click Help.

When I click yes, the heading formatting disappears (headers are no longer
adjusted).
When I save in the latest Excel format, the file is not available when I go
to import it into Outlook (it doesn't appear in the list of files available).

When I import the file without the header adjustment, all I get is the name
and phone number of each contact, not the address, second phone, etc. Thanks
for reading this and helping.


 




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
Data limitation when importing contact file from excel David Burrows Outlook - Using Contacts 7 March 13th 08 12:47 PM
recurrence lost on importing excel data to Outlook calendar MonLou Outlook - Calandaring 0 March 14th 07 02:25 PM
Difficulty importing EXCEL data into Outlook Contacts Robert Judge Outlook - Using Contacts 0 December 27th 06 02:06 AM
Importing data from Excel to Outlook I get error too many fields phd Outlook - Using Contacts 0 July 9th 06 10:10 PM
Can I create a contact list by importing data from excel? Steve Peek Outlook - Using Contacts 3 June 18th 06 12:42 AM


All times are GMT +1. The time now is 11:49 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.