Export Custom Task Form Data to Excel

[eric.fader]

Hi:

I created a custom task form within Outlook and would like to export
that data in custom fields to excel. Can anyone provide guidance on
how to accomplish this because Outlook does not have a record macro
function.

I am looking for code samples to get me started or a relevant
tutorial.

Thanks in advance,
Eric

 

[Sue Mosher [MVP-Outlook]]

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