 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / February 2006HELP HELP - Importing Contacts from Excel List
I have imported a Contact list of Excel. But when I look in my address book under Contacts my list is not complete. Is there a limit to how many contacts you can import? I have over 2000. Also is there a way to eliminate the "file" version of the contact I just want the name, ph and fx number to show. My Excel sheet consists of three columns Name, ph and fx number. I would like to get this rights others will need to import the same list to their address book. Thank you. No such limit. It appears you did not import correctly. Look in your Contacts Folder and see. Are the email addresses mapped to the correct field? Are they valid and resolved?  SignatureRuss Valentine [MVP-Outlook] >I have imported a Contact list of Excel. But when I look in my address >book [quoted text clipped - 7 lines] > would like to get this rights others will need to import the same list to > their address book. Thank you. I mapped the field correctly. I did not use an email address on these contacts we do not need only need name, ph and fax numbers. If the list is not showing when I open the address book and go to contacts then where would they be? Is there somewhere where I can see an example or walks you through step by step? Any help will be greatly appreciated. > No such limit. It appears you did not import correctly. > Look in your Contacts Folder and see. [quoted text clipped - 11 lines] > > would like to get this rights others will need to import the same list to > > their address book. Thank you. Only electronic addresses appear in the Outlook Address Book. Did you store your fax numbers in a fax field and are they resolved? SignatureRuss Valentine [MVP-Outlook] >I mapped the field correctly. I did not use an email address on these > contacts we do not need only need name, ph and fax numbers. If the list [quoted text clipped - 23 lines] >> > to >> > their address book. Thank you. yes I stored the fax numbers in the business fax field. What do you mean are they resolved. Thank you. > Only electronic addresses appear in the Outlook Address Book. > Did you store your fax numbers in a fax field and are they resolved? [quoted text clipped - 25 lines] > >> > to > >> > their address book. Thank you. Underlined. That indicates Outlook recognizes them as valid electronic addresses. If they're not underlined, they won't show up. SignatureRuss Valentine [MVP-Outlook] > yes I stored the fax numbers in the business fax field. What do you mean > are [quoted text clipped - 34 lines] >> >> > to >> >> > their address book. Thank you. Russ, I've always been confused by this issue of address book vs. Outlook contacts. You're right that Outlook contacts that don't have valid electronic addresses don't appear in the address book, but I'm left wondering what the address book is used for when you have Outlook contacts? I guess the question for TotallyConfused has to be; do the contacts that don't appear in the address book appear in the Outlook contacts folder? If they do, then you did import them correctly, but as Russ says, some of them don't have resolved electronic addresses. Mark > Underlined. That indicates Outlook recognizes them as valid electronic > addresses. If they're not underlined, they won't show up. [quoted text clipped - 36 lines] >>> >> > to >>> >> > their address book. Thank you. Actually there is very little use for the Address Book in Outlook. It is simply a listing of all the electronic addresses in the Contacts Folder. It is usually better to use the Contacts Folder directly to access Contacts data. That's the way Outlook was designed. The Address Book view is created for those users who cannot wean themselves from the address book concept. SignatureRuss Valentine [MVP-Outlook] > Russ, > [quoted text clipped - 53 lines] >>>> >> > to >>>> >> > their address book. Thank you. okay what I am understanding is if I do not have an email and it is not underscored then my contact will not appear in my contact folder? Then how do you explain the contacts that did make it to my contacts folder. Is there anyway around this? I just need to have Name, phone number and fax number. What I am doing with these contact's fax numbers, I am faxing from Outlook. So only fax numbers and names are important right now. Any help will be greatly appreciated. thank you. > Underlined. That indicates Outlook recognizes them as valid electronic > addresses. If they're not underlined, they won't show up. [quoted text clipped - 36 lines] > >> >> > to > >> >> > their address book. Thank you. Do not confuse the Contacts Folder with the address book. All data is stored in the Contacts Folder. No data is stored in an address book. The address book is simply a view of the electronic addresses that in your Contacts Folder. SignatureRuss Valentine [MVP-Outlook] > okay what I am understanding is if I do not have an email and it is not > underscored then my contact will not appear in my contact folder? Then [quoted text clipped - 52 lines] >> >> >> > to >> >> >> > their address book. Thank you. |
Reply to this Message |
 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.