 |
 | 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 / November 2007Viewing Contacts in Excel
Is there a way to view all my Outlook contacts in a grid form like in Excel? yes. Turn on the Advanced Toolbar and use the white window that says Address Cards to change to a table view. Phone List is good. You can look at various Views in each folder. Regards Judy Gleeson MVP Outlook Trainer and Consultant There are various articles about using Outlook here: www.judygleeson.com Canberra, Australia > Is there a way to view all my Outlook contacts in a grid form like in > Excel? I assume that you want the results fully exported to Excel, not simply viewing it in Outlook, right? I noticed on puzzlenyc.org this answer: In Outlook, select File > Import and Export This starts a wizard containing several steps. 1. Select Export to a File 2. Select Microsoft Excel for the file type. (Personally, I would recommend Comma Separated Values (windows) as the file type. It seems to be a more flexible option, and Excel can read these types of files, as well. 3. Make sure you select the CONTACTS folder as the folder you want to export from 4. Select the file location and / or modify the file name 5. Confirm all is correct. If necessary you can map custom fields, but this can get quite complicated. I would just take the defaults. They work quite well. 6. Click Finish - Hope this works. There are some more details on the puzzlenyc.org site such as what to look for when you do this conversion. Worth reading it. Gosh, so much work... just make a table view in Outlook and copy and paste them into Excel. All of the fields in the view will copy, so if you make a view with just the name and phone number that is all that will be copied.  SignatureDiane 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: dailytips-subscribe-request@lists.outlooktips.net Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Subscribe to Exchange Messaging Outlook newsletter: EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM > I assume that you want the results fully exported to Excel, not simply > viewing it in Outlook, right? I noticed on puzzlenyc.org this answer: [quoted text clipped - 18 lines] > - Hope this works. There are some more details on the puzzlenyc.org site > such as what to look for when you do this conversion. Worth reading it. He just said he wants to view them in a grid form "like Excel" not in Excel. So I think I answered this. Regards Judy Gleeson MVP Outlook Trainer and Consultant There are various articles about using Outlook here: www.judygleeson.com Canberra, Australia > Gosh, so much work... just make a table view in Outlook and copy and paste > them into Excel. All of the fields in the view will copy, so if you make a [quoted text clipped - 23 lines] >> - Hope this works. There are some more details on the puzzlenyc.org site >> such as what to look for when you do this conversion. Worth reading it.
|
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
|
©2008 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.