How can I add to the Map Custom Fields in Outlook which I need to.

[Boselli]

I have created a message form in Outlook 2003 which is being used in the
office. I now need to export text from these forms into an excel spreadsheet
however 4 of my user defined fields that I created do not show up on the Map
Custom Fields option when I export. I think they need to belong to the all
mail fields group for them to show up in Map Custom Fields but I don't know
how to get them there.
Please could you help? Thank you.

 

[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

 

[Boselli]

Hi Sue,

thank you for your reply. I had subsequently found your reply to a similar
question and tried this which works fine but I will have a go writing my
custom VBA code too.

Thanks for your help.
Boselli