Collect+Data+via+Email

=Collect Data via Email=

MyAccessProgram

To collect data or update data by email, use the following steps.

1. Open database which contains email field. 2. Click on External Data. 3. Click on Create Email. 4. A wizard window pops up. Choose HTML form. 5. Update existing information. 6. Choose all fields that you need in this table. Don't need email field. 7. Can change label for each field in the field properties below. 8. Choose automatically process replies and only allow updates to existing data. 9. You can discard replies from those to whom you did not send the message to. 10. Choose number of replies to be processed. Can also pick date and time to stop. 11. Select email address field, should be already selected. 12. Change subject and introduction wording in email. 13. Select who gets the email. 14. Recipient must click Send to submit information. 15. Outlook will automatically update information that is emailed back.