Thread
:
Viewing Contacts in Excel
View Single Post
#
5
November 16th 07, 11:25 AM posted to microsoft.public.outlook.contacts
Judy Gleeson \(MVP Outlook\)
external usenet poster
Posts: 1,046
Viewing Contacts in Excel
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 he
www.judygleeson.com
Canberra, Australia
"Diane Poremsky" wrote in message
news
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.
--
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:
"gstar" wrote in message
...
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.
Judy Gleeson \(MVP Outlook\)
View Public Profile
View message headers
Find all posts by Judy Gleeson \(MVP Outlook\)
Find all threads started by Judy Gleeson \(MVP Outlook\)
Ads