Hi All,

I have designed an Excel user form (integrated to Access database) where
multiple users will fill up the form(the details will populate access
database)

What I want is: Once they fill up the form and click submit, I want to get
an email in my microsoft outlook email inbox with the details the user filled
(can be an excel sheet with the details user filled in the form). The excel
sheet should have an 'Accept' and a 'Decline' button. If I hit 'Accept', I
want it to populate my access Database with the details, If I hit 'Decline',
I want it to populate the details into a seperate excel sheet on shared drive.

Is this possible?

Thanks in Advance.

This seems like it will take a bit of work, but definitely doable.
This should get you started:
http://www.rondebruin.nl/sendmail.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"sam" wrote:

Hi All,

I have designed an Excel user form (integrated to Access database) where
multiple users will fill up the form(the details will populate access
database)

What I want is: Once they fill up the form and click submit, I want to get
an email in my microsoft outlook email inbox with the details the user filled
(can be an excel sheet with the details user filled in the form). The excel
sheet should have an 'Accept' and a 'Decline' button. If I hit 'Accept', I
want it to populate my access Database with the details, If I hit 'Decline',
I want it to populate the details into a seperate excel sheet on shared drive.

Is this possible?

Thanks in Advance.