Button to Collect Data from Outlook



Can anyone help me add a command button to a form that will enable the user
to send an html form to email recipients who will update the form, send it
back, and the data will automatically be processed by Outlook and
incorporated into the Access database? I understand how to accomplish this
in Access by opening a table > external data > collect data > create email.
However, I would appreciate any help you can provide. Thanks!



I'm not aware of any way that Outlook can update an Access database.
Well there may be, but it would require some complex coding in Outlook and
this is not an Outlook forum.
What exactly are you trying to achieve? There is possibly a better way to do
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


Thanks for your reply Dorian. Outlook can update data in Access 2007. It's
called the "Collect data through e-mail messages Wizard." You can also go to
the help menu and run a search on "collect data." Like I mentioned in my
original post, I've made it to that step already. What I want to do now is
to create a form with a command button that when pressed by the user will
open an applicatoin (Outlook) with the html form included. The user clicks
send and off we go....

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