Exporting Contacts and custom fields to excel

  • Thread starter Thread starter gregcool
  • Start date Start date
G

gregcool

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?
 
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.

--
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
 
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
--
___________________________________
Karl Timmermans - The Claxton Group

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