Extracting Data from Outlook Forms

B

BVH

Hi,

Wondering if anyone can help me. I have over a 1000 forms
with emergency contact information from employees. Instead
of keying them in manually I would like to extract the
data from the forms into a .csv file which I can then
upload into our HR system.

The form is a custom form. I have tried Exporting but
custom field data is not being transferred across.

Any help is much appreciated.

Many thanks

BVH
 
S

Sue Mosher [MVP-Outlook]

Outlook doesn't support exporting custom fields. 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.

Otherwise, you'd have to write custom code or use a third-party application.
See http://www.outlookcode.com/d/customimport.htm .
 

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.

Ask a Question

Top