Capturing Data from a form into excel

[Diego]

Hi,

Is there a way to capture data from an outlook form into an excel file?

Sorry but I am new to outlook forms.


Thank you!

 

[Sue Mosher [MVP]]

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