Export Custom Fields

[crwnsvn]

Created custom field called "Login". Populated this field with data and
would like to export this field to a Excel File. Whithin "Export to a File"
dialog box, I click on "Map Custom Fields". The custom field I created is not
listed there. Does anyone know how to export a custom field. Thanks!!!

 

[Sue Mosher [MVP-Outlook]]

Outlook doesn't support exporting custom fields directly. 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.

If some of the fields are multi-line, see Eric Legault's handy tip for an Excel formula to break up the lines -- http://blogs.officezealot.com/legault/archive/2005/04/08/4502.aspx

The alternatives are to write your own custom VBA code or to use a third-party application. See http://www.outlookcode.com/d/customimport.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[JonMulder]

After the data (including the "user-defined" fields) are copied (not
exported) to Excel using this procedure, can they be pasted (not imported)
back in? I wanted to manipulate my e-mail address in Excel (globally replace
mail-domain string) then pull back into Excel. Unfortunately, I have some
"user-defined" fields and that is hanging me up.

 

[Sue Mosher [MVP-Outlook]]

No, you can't copy and paste data into Outlook. Use one of the other methods on the second page I suggested.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers