Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2011
    Posts
    284
    Thanks
    33
    Thanked 2 Times in 2 Posts

    MS Access 2007 - updating data by HTML E-mail

    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........!

  2. #2
    3 Star Lounger
    Join Date
    Jan 2011
    Posts
    284
    Thanks
    33
    Thanked 2 Times in 2 Posts
    Oh - yes.... another question....

    If you were to copy the code of the e-mail form and paste it on a website which will send a mail back to you, would that work?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2011
    Posts
    284
    Thanks
    33
    Thanked 2 Times in 2 Posts
    One more question....... If the Access tables are linked to an Excel spreadsheet, will the incoming data be pasted to the excel spreadsheet? The reporting requirements are such that you can't get them out of Access - there are just too many calculations to do! So I want to be able to do them from Excel, based on Access tables, or on the excel sheets that I can link from Access.

    The options available are:
    - have an Access database with native Access tables. You then need to export these tables to Excel, and run analysis on them for reports.
    - have an Access database with linked Excel tables. Does the e-mailed data get added to the Excel Spreadsheet? Then the reports can simply be printed.

    Does anyone have experience with this? Thanks

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    I have not used this feature of Access (collecting data via email) , but Access can not update linked Excel data. It used to be able to do that, but Microsoft withdrew that capacity after a court case some years ago.
    Regards
    John



  5. #5
    3 Star Lounger
    Join Date
    Jan 2011
    Posts
    284
    Thanks
    33
    Thanked 2 Times in 2 Posts
    Hi John

    Thanks for that - it's a real pity.... it would make life much easier!
    It looks like I won't really be using Access after all any more. I will just have to stick to the Excel spreadsheets!
    Thanks for the info......

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •