Submit InfoPath Form Content to Access DB and E-mail at once

[Sembrey1]

I can't seem to make my submit button send the form data to an email and
update my Access database at the same time. I can only do one or the other at
a time. I followed the "Submitting form data to multiple data sources at
once" and I just cannot create 1 rule for e-mail and a 2 rule for DB. The
option for database is not there in creating a "Rule" Please help.

 

[Uma]

No, you can make your submit button send the form data to an email and update
your Access database at the same time by doing the mail functionality through
the code.

But the other way is using the combination of a rule with more than one
action.
1. Create one main data source connection for the Access data base.
2. Create one email data connection to send the mail in your InfoPath form.
3. Take one button into your InfoPath form and go to button properties.
4. Click on rules to add a rule for the button.
5. Click on “AddAction†and select “submit using data connection†and select
the main data connection to submit the data to your data base.
6. Repeat the step 5 by selecting the email data connection for the submit
using data connection option.
Note: First you have to submit the data to data base and next you can do
sending email through the rules. And you can set the condition also for the
rule using “set condition

 

[ridawg]

Just a quick question. I'm trying to just submit to a database but I'm using
a rule 'cause after the submit I want to switch views. How do I get a
success/failure message regarding the submitted data when using a rule to
submit data instead of the default InfoPath Submit action?

Thanks