change the custom fields when export emails to excel

S

smiler_rossy

Want to use specifed forms and then export these specfied fields into an
excel file
 
S

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/article.aspx?ID=23
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I add to the Map Custom Fields in Outlook which I need to. 2
custom forms 2
Export Outlook 2000 Forms to Excel 7
Custom Fields - Deleting And Where Are They Saved 8
Fields and custom fields 0
Export Excel Table to Form Message 3
Exporting a form with custom fields 1
Export Custom Task Form Data to Excel 1

Top