Exporting Outlook form fields

[Derek Wittman]

Good afternoon
I have an Outlook form that I set up (thanks to Sue Mosher for instructions on her site - www.slipstick.com - for publishing to Organizational Forms Library). I have fields set up within the form that I would like to export into a new line in an Access data table. The data table is a 'log file' for requests coming into my desk and needs to be kept current and accurate, and will be treated similarly to a Help Desk concept

Can someone help me with setting up fields to export? Are there add-ins out there somewhere to do this

Thank you
Derek

 

[Sue Mosher [MVP]]

Outlook doesn't support exporting custom fields. You'd have to write custom code or use a third-party application. See http://www.slipstick.com/dev/customimport.htm.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

 

[Jonathan Parminter]

-----Original Message-----
Good afternoon,
I have an Outlook form that I set up (thanks to Sue

Mosher for instructions on her site - www.slipstick.com -
for publishing to Organizational Forms Library). I have
fields set up within the form that I would like to export
into a new line in an Access data table. The data table
is a 'log file' for requests coming into my desk and needs
to be kept current and accurate, and will be treated
similarly to a Help Desk concept.

Can someone help me with setting up fields to export?

Are there add-ins out there somewhere to do this?

Thank you!
Derek
.

Hi Derek.
I'm not sure that you do need to export this. In Access
using Tools | Get external data, you can link to an
Outlook folder. You then use this in Access as if the data
is a native table.

Luck
Jonathan

 

[Sue Mosher [MVP]]

Nope, that won't work. The linked tables technique can't even expose all the built-in fields, much less custom fields.

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.slipstick.com/dev/customimport.htm.

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers