Submitting 2003 form to Access and to Email

CanadianEh? — Fri, 22 May 2009 00:10:21 GMT

I'm a novice user of both Access and InfoPath however, I managed to build my Access dbase and InfoPath form as I wanted with one excepetion.

Currently, users submit the form to the database and via email conquerantly using one Submit button.

My problem is, my coworker would like for users to have the ability to attach a .dwg file to the email when submitting the form. One way to do this is for users to email the form via File -->Send to Mail Recipient and then attaching the appropriate .dwg file to the Outlook email. They would then have click on a "submit" button for the form to be submitted to the database. I'm hoping there's a way to eliminate these two steps.

What I want is:

1. User clicks on "submit button" --> Email window opens up and allows user to attach additional files (.exe, .doc, .dwg etc.) to the email.

2. After email is sent, message is displayed to inform user that email was sent successfully.

3. InfoPath form data is then automatically submitted to Access dbase.

If the above is not possible, we will just have to ask users to create a hyperlink to the file locations.

Originally I wanted users to be able to attach the file right into the form but even if I figured that out, I decided that I didn't want to bog down the database with CAD files that are already located on our server.

Thank you!

SQL Database Integration

Submitting 2003 form to Access and to Email