Submitting via MS Access DB and using EMAIL

[Andrea L]

Hello,

I have a form that when you submit it goes to an Access database. I would
like to fire off an email to someone to let them know a submission was made
so they can review the form. Is there a way when you submit to submit to a db
and to email?

 

[S.Y.M. Wong-A-Ton]

Create a new data connection through "Tools > Data Connections..." to sumbit
to an email address. Then go to "Tools > Submitting Forms", change the
"Submit to" field to "Custom submit using rules", and then click on the
"Rules..." button to create 1 rule with 2 actions: The first action must
submit using the data connection for the database (this data connection was
created when you first created your form and bound it to the database), and
the second action must submit using the data connection for the email.

 

[Andrea L]

THANK YOU FOR YOUR HELP!! This worked great.

 

[S.Y.M. Wong-A-Ton]

Glad I could help.
---
S.Y.M. Wong-A-Ton

THANK YOU FOR YOUR HELP!! This worked great.