Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / December 2003

Tip: Looking for answers? Try searching our database.

Exporting Contacts and custom fields to excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
gregcool - 12 Dec 2003 17:56 GMT
I am having trouble building an excel spreadsheet that
will capture the custom fields I have made for my contact
list.  Anyone know how to do this?
Sue Mosher [MVP] - 12 Dec 2003 20:49 GMT
Outlook doesn't support exporting custom fields. Quick and dirty method:

1. Put all the items from your form in one folder.
2. Use a table view to display all the data fields that you want to export to Excel.
3. Choose Edit | Select All.
4. Choose Edit | Copy.
5. Paste to Excel.

Otherwise, you'd have to write custom code or use a third-party application. See http://www.slipstick.com/dev/customimport.htm.

Signature

Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
    Microsoft Outlook Programming: Jumpstart
    for Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx 

> I am having trouble building an excel spreadsheet that
> will capture the custom fields I have made for my contact
> list.  Anyone know how to do this?
Karl Timmermans - 13 Dec 2003 04:58 GMT
If you're interested, you're welcome to try an early beta copy of our new
new version. It doesn't have an "export facility" as such, but it does
create an optional output XML file of records selected to be imported (in
this case the Outlook would be your data source) which can then be imported
into Excel (2002/2003). You can select whatever fields you like including
any on a custom form.

Just contact me directly and you will provided with the appropriate
information if you want to pursue this.

Karl
Signature

___________________________________
Karl Timmermans - The Claxton Group

ContactGenie - "automated contact importer for MS Outlook '2000/2002
http://contactgenie.claxton.com

> I am having trouble building an excel spreadsheet that
> will capture the custom fields I have made for my contact
> list.  Anyone know how to do this?
 
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.