Collecting data over email


show more Collecting data over email provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Collecting data over email

If you'd like to have your customers fill in their own information for your database, you can send them an interactive e-mail that will automatically update the records. It doesn't matter what kind of e-mail program they have. For example, let's say we want all of our Sales reps to verify that we have the correct contact info for them. Click once on the SalesReps table. Go to the External Data tab and on the far right, click on Create E-mail. There is a set of instructions. Click Next. Specify if you want normal HTML formatting, or InfoPath. We want HTML.

Click Next. Choose if you want them to create new records for your database or update already existing information. We want to update their data. Click Next. Now you can choose what field do you want them to verify. We will move them all over but then move back, Flag. If you want them to see labels other than your actual field names, you can modify them here. I'll change Email to Email Address and click Next. We want to Automat...

Collecting data over email
Video duration: 2m 42s 3h 30m Beginner

Viewers:

Collecting data over email provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...