|
| 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. |
|
|||||||
| Tags: driving, mad, outlook |
|
|
Thread Tools | Display Modes |
|
#1
May 2nd 08, 05:05 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Outlook driving me mad!
Hi,
I am trying to import my contacts from an Excel spreadsheet into Outlook. I feel like I have tried EVERYTHING! I have saved my data as both an excel spreadsheet and in CSV format. I have made sure the columns AND the range of data is identified. I check and check again to make sure my fields are mapped correctly. I have tried eliminating symbols that might interfere (even though I don't see why they would). Every time I do the import, all of the data is imported EXCEPT for the address.... it gets the name, city, state, phone etc etc but ALWAYS leaves out the address! Does anyone know why this is happening and how I can fix it? If so, I would greatly appreciate some help. Thanks! JPorter 
|
| Ads |
|
#2
May 2nd 08, 05:20 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Outlook driving me mad!
is the full address in one cell or is the street address in a cell separate
from the city, state and zip? Try changing the street address field to the one outlook uses so it doesn't need mapped. the address fields a BusinessStreet BusinessStreet2 BusinessStreet3 BusinessCity BusinessState BusinessPostalCode BusinessCountryRegion HomeStreet HomeStreet2 HomeStreet3 HomeCity HomeState HomePostalCode HomeCountryRegion OtherStreet OtherStreet2 OtherStreet3 OtherCity OtherState OtherPostalCode OtherCountryRegion -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Subscribe to Exchange Messaging Outlook newsletter: "JPorter" wrote in message ... Hi, I am trying to import my contacts from an Excel spreadsheet into Outlook. I feel like I have tried EVERYTHING! I have saved my data as both an excel spreadsheet and in CSV format. I have made sure the columns AND the range of data is identified. I check and check again to make sure my fields are mapped correctly. I have tried eliminating symbols that might interfere (even though I don't see why they would). Every time I do the import, all of the data is imported EXCEPT for the address.... it gets the name, city, state, phone etc etc but ALWAYS leaves out the address! Does anyone know why this is happening and how I can fix it? If so, I would greatly appreciate some help. Thanks! JPorter
|
|
#3
May 2nd 08, 05:29 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Outlook driving me mad!
I have the street address (including suite number) in one column, separate
from city, state, and zip which are all in their own columns. Are you saying I should consolidate all of the address info into one column (address together with state, zip, etc) or separate it as much as I can into individual fields? "Diane Poremsky {MVP}" wrote: is the full address in one cell or is the street address in a cell separate from the city, state and zip? Try changing the street address field to the one outlook uses so it doesn't need mapped. the address fields a BusinessStreet BusinessStreet2 BusinessStreet3 BusinessCity BusinessState BusinessPostalCode BusinessCountryRegion HomeStreet HomeStreet2 HomeStreet3 HomeCity HomeState HomePostalCode HomeCountryRegion OtherStreet OtherStreet2 OtherStreet3 OtherCity OtherState OtherPostalCode OtherCountryRegion -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Subscribe to Exchange Messaging Outlook newsletter: "JPorter" wrote in message ... Hi, I am trying to import my contacts from an Excel spreadsheet into Outlook. I feel like I have tried EVERYTHING! I have saved my data as both an excel spreadsheet and in CSV format. I have made sure the columns AND the range of data is identified. I check and check again to make sure my fields are mapped correctly. I have tried eliminating symbols that might interfere (even though I don't see why they would). Every time I do the import, all of the data is imported EXCEPT for the address.... it gets the name, city, state, phone etc etc but ALWAYS leaves out the address! Does anyone know why this is happening and how I can fix it? If so, I would greatly appreciate some help. Thanks! JPorter
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook Pop Up Driving me Crazy | Hal | Outlook - Using Contacts | 0 | August 3rd 07 05:40 PM |
| Please help Outlook Express is driving me crazy! | Didi | Outlook Express | 18 | November 14th 06 10:25 AM |
| "Do you want to allow this" messages driving me mad! Tried Clickyes and Redemption | Biguana | Outlook and VBA | 10 | October 2nd 06 03:41 PM |
| how do i remove microsoft outlook it is driving me nuts | how do I uninstall microsoft outlook | Outlook - Installation | 1 | May 5th 06 08:15 AM |
| Driving me nuts! | duaneorama@gmail.com | Outlook - Using Forms | 0 | April 12th 06 05:52 PM |
Linear Mode
