change the custom fields when export emails to excel

  • Thread starter c21pbGVyX3Jvc3N5
  • Start date Views 2,124
Status
Not open for further replies.
C

c21pbGVyX3Jvc3N5

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

excel file
 
S

Sue Mosher

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

Sue Mosher

"smiler_rossy" wrote:


> Want to use specifed forms and then export these specfied fields into an
> excel file
 
Status
Not open for further replies.
Top