*forgot to mention I'm trying to accomplish Scenario 2 - I just want to send the email from Outlook using some of the data from the form.
AND, as if things aren't complex enough, I would like to send the email 7 days after the date the form is completed.