Solved

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?

Posted on 2014-10-15
5
302 Views
Last Modified: 2014-10-19
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?
0
Comment
Question by:Frank Vertin
  • 3
5 Comments
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40382395
The automatic email feature was removed in A2010 or A2013.

You can still do it yourself but it is much harder.  You can create spreadsheets and send them out then have Access process them on return.

If you have A2007 available (I don't so I can't verify or give instructions) see if you can find the feature.  If not, we'll need more details to help with the creation of a custom process.
0
 
LVL 57
ID: 40382397
Access actually had this as a feature; which Microsoft just removed in Access 2013.  Since you have 2007/2010 though:

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.
0
 
LVL 57
ID: 40382407
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.
0
 

Author Comment

by:Frank Vertin
ID: 40382796
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?
0
 
LVL 57
ID: 40382992
<<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.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Query Optimization 14 42
Access denied running PowerPivot -SQL Server 2014 on Windows Server 2012 10 28
Return 0 on SQL count 24 28
SQL View nearest date 5 35
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question