I wonder if anyone has had experience of a scenario like this:
Access 2007 has a function that will create an e-mail html form that you send to your recipients. They fill in the details and e-mail it to you. Outlook will automatically add the info to your database, in the table you want – seems like magic!
I want to know if the respondents use something other than Outlook, if the result will be the same – namely the inclusion of a new record in the database.
I would also like to know if you can create a table within the e-mail to send out that will populate more than one row in that e-mail.
I have a project that requires 5 Inspectors to report on around 4 different activities each day. They need to report what is being done under those different activities at a few different houses each day. So far I have had them collate the info into a spreadsheet each day and e-mail that to me. I then need to copy and paste the data into another spreadsheet, and then run an analysis to get a report out when the client wants one. I am looking for a quicker, easier way of doing this.
Would this work with Outlook 2003, for example, or Thunderbird e-mail client?
Thanks for your help, experience and guidance……..!
