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.
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
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.
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.
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.
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
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.