Export Outlook 2000 Forms to Excel

[Marilyn]

Hello All,

How can I export outlook forms to Excel? I tried but the custom fields dont
carry over. Please Help!!

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

 

[Marilyn]

Thanks for the Reply Sue,

The custom Form is a Mail Form and according to my Outlook view it's already
setup as a Table View. Is there something I'm missing?

Thanks,

 

[Sue Mosher [MVP-Outlook]]

Steps 2-5? You didn't say whether you'd actually tried them.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

 

[Marilyn]

Ok, the form is in a message view and according to the view it's already in
TABLE View, so please tell me what i'm missing in your instructions, cause i
go to View, Arrange By, Customize Current view, and I dont see anything for
Table view.

Thanks again,

 

[Sue Mosher [MVP-Outlook]]

I don't know what you mean by "message view." Table is one of five different types of folder views. If it's already in a table view and contains all the fields you want to export, then you need to follow steps 3-5 to copy and paste to Excel. If not, create a new table view and add fields.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

 

[Marilyn]

Sue,

I have a subfolder under my inbox which contains the custom forms i want to
export. I created a new view and identified as a Table view, however, I'm
not able to add the custom fields located in the form in that Mail items
folder. I think we are somehow confusing each other. I know how to copy and
paste, what i'm having problems with is creating the table view and showing
all the fields in that custom form.

Thanks,

 

[Sue Mosher [MVP-Outlook]]

Since you are not using a default folder, you need to add the custom fields by clicking the New button on the folder's Field chooser. Do this for each field you want to export, entering the correct data type and name for each field. This will define the fields in the folder. After so that, you can then drag the fields from the Field Chooser to the column headings of the table view. That should make the data visible so that you can copy and paste it.

BTW, what the folder contains are items, not custom forms. Forms are merely the UI/code templates; they contain no data.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54