Frank Vertin
asked on
How do I Perform sending table information, as a form, in an email so that the information can be entered by the reciprient, sent back by email and the data is entered into a table, automatically?
I did it once many years, ago when I was taking a statistical class. I was able do surveys by email. I need to do this in the medical industry. The tutorials that I've been able to check out for 2010 show only 2007 version in the video while claiming that it's 2010.
I'm doing this in MS Access 2010, but personally have 2007 & 2013.
I have an old computer, a VISTA WITH 2007. Trying to follow the Tutorial when selecting "Create Email" I got a corrupt add-in error and got to wondering, do I need an add-in to do this? 2010 and 2013 look different from 2007, is that caused by the add-in?
I'm doing this in MS Access 2010, but personally have 2007 & 2013.
I have an old computer, a VISTA WITH 2007. Trying to follow the Tutorial when selecting "Create Email" I got a corrupt add-in error and got to wondering, do I need an add-in to do this? 2010 and 2013 look different from 2007, is that caused by the add-in?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I just double checked; it was partially removed in 2013. You can no longer create forms, but Access 2013 will still process data from forms created in earlier versions.
Jim.
Jim.
ASKER
Thanks, I have Access 2007, but I need to do this in an Access2010 environment. I read somewhere, today, that I need to include an Excel spreadsheet on which the data is carried. Is there anyway to automate the process?
<<Is there anyway to automate the process? >>
Yes, you can easily set up a button to export the data to a spreadsheet or do it as a part of any process.
Access has the built-in TransferSpreadsheet command, which lets you output a table or query into a spreadsheet.
Beyond that, using OLE automation you can open an instance of Excel and build a spreadsheet cell by cell if you wish (or do anything you can do in Excel - the full Excel object model is available).
Jim.
Yes, you can easily set up a button to export the data to a spreadsheet or do it as a part of any process.
Access has the built-in TransferSpreadsheet command, which lets you output a table or query into a spreadsheet.
Beyond that, using OLE automation you can open an instance of Excel and build a spreadsheet cell by cell if you wish (or do anything you can do in Excel - the full Excel object model is available).
Jim.
Collect data by using e-mail messages
https://support.office.com/en-US/Article/Collect-data-by-using-email-messages-800daef3-86d3-4b62-9a2c-a4e41a14fa98
This is a step by step.
also a demo of the feature here:
https://support.office.com/en-us/article/Demo-Collect-data-in-Access-2007-by-using-email-2b8f8b1a-05e6-4213-ae91-1f79d71b0468
Let me know if you need anything else. I haven't actually used this myself though, but I should be able to steer you through the process or someone else may jump in that has a little more knowledge on it if you need something else.
Jim.