Prev: Hide one page within a form with several pages
Next: Strange Date
From: *Glen* on 13 Jan 2010 16:21
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!

*Glen*
From: Dorian on 13 Jan 2010 16:32
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
it.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"*Glen*" wrote:

> 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!
>
> *Glen*
From: *Glen* on 14 Jan 2010 09:26
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....

"Dorian" wrote:

> 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
> it.
> -- Dorian
> "Give someone a fish and they eat for a day; teach someone to fish and they
> eat for a lifetime".
>
>
> "*Glen*" wrote:
>
> > 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!
> >
> > *Glen*
 | 
Pages: 1
Prev: Hide one page within a form with several pages
Next: Strange Date