How do I export outlook form data into a spreadsheet

[Guest]

I have 2 issues in regard to this.

I am trying to export data in an attendance form that was created in Outlook
with custom fields (not using VBA) into an existing Access database.
Unfortunately, when I try to export the data, it only exports the To, From,
CC, etc. data but not the data entered into the form (name, occurrence,
benefits, etc.). Does anyone have any ideas on how to do this?

I also need the end user to be able to do the export from Outlook without
using the import function in Access. I have MS Access but other users do
not. I was thinking of a button on the form that automatically will import
the forms data when clicked but I do not have a programming background. Can
anyone help me with this?

From,
Christy

 

[John Nurick]

Hi Christy,

What you want is possible (including moving the data into the database
without actually using Access) but it can't be done without a good
knowledge of Outlook VBA programming, which not many people here have.

Probably the best single resource for Outlook programming is
www.outlookcode.com. In addition there are the Outlook programming
newsgroups, where you're more likely to find people who can answer your
question.