Beginning with version 2007, Microsoft Access included a feature that seamlessly links your database table to Outlook and makes it easier to collect user data via email messages. This quick tutorial will show you the steps for setting up the email template for collecting the data as well as the steps for processing the collected data.
Creating the email message
Follow these steps to create the email message:
Select the table that you need to collect the data for from the Navigation Pane.
From the External Data tab on the Ribbon, in the Collect Data group, click on the Create E-mail button.
The Collect data through e-mail messages Wizard should open as show in Figure 1.
Click Next. The next screen will present you with the option to choose the type of email form you want to use. You can only use either HTML or InfoPath forms (see Figure 2).
Select HTML if your users do not have InfoPath installed on their machines.
Click Next after you have made your choice.
If your table contains existing data, the next screen that shows up is where you’ll choose whether the data you’re collecting are new information or for updating the existing data in your table (see Figure 3).
Click Next after you have made your selection.
The next screen (see Figure 4) allows you to select which fields from your table you would like to include in the email message for collecting the data. You can set the order of the fields or change the label captions for each field.
After you have selected all the fields you want to collect, click Next to see the next screen (see Figure 5).
This screen allows you to specify which Outlook folder will be used to store the email replies for the collected data. You can change the default location by clicking on the folder’s name and then switch to the Outlook window and select or create a new folder (see Figure 6).
From the same screen (see Figure 5), you can also specify if you want all email replies to be processed automatically, which means that the data collected will be automatically added to your Access table. To control how the data is processed, you can click on the link labeled “Set properties to control the automatic processing of replies.” This would open up the Options screen (see Figure 7).
From the screen shown in Figure 5, click Next to move on the next step.
The next screen specifies how you would like to provide the email addresses for the recipients of your message (see Figure 8).
If you select to provide the email addresses from an Access table, clicking Next will present the screen shown in Figure 9.
Select the email address field from the current or related table and then click Next.
The next screen allows you to specify the subject line and body of the message (see Figure 10).
Click Next to see the next screen (see Figure 11). This screen is informational only.
Click Next again. The next screen allows you to select specific recipients for the email message, send the message to all recipients (see Figure 12).
When you’re ready to send the email message, click Send.
When your users get the email message, all they have to do is reply back by filling out the form in the message with the information being requested.
Managing Automatic Reply Processing
After you have set up your data collection email, you can go to the Message Options screen to change its settings. To do so, follow these steps:
From the External Data tab on the Ribbon, in the Collect Data group, click on the Manage Replies button. The Manage Data Collection Messages dialog window should come up (see Figure 13).
With the data collection message template you want to modify highlighted, click on the Message Options button.
The Collecting Data Using E-Mail Options dialog window should open up (see Figure 14).
From this screen, you can check or uncheck the options you prefer.
Click OK to close the Options window.
Click Close on the Manage Data Collection Messages dialog window.
If you did not set up your email data collection to be processed automatically by Outlook, or if a reply failed to be processed, you can manually process each reply by following these steps:
Locate the folder you designated for storing the collected data in Outlook.
Right-click on the user’s reply you want to process and select Export data to Microsoft Access.
On the Export data to Microsoft Access dialog window, verify the data to be added to the table and click OK.
If the export is successful, you should get the confirmation window shown in Figure 15.
You must repeat these steps for each reply you want to process.
Since Access 2007, database developers can now automate external data collection via email messages using Outlook. If you have users who need to send out surveys or questionnaires and want to avoid the manual process of collecting feedback, you might consider giving this new feature a try. More importantly this type of integration is actually possible via a web browser and in the cloud with Access hosting’s remote desktop hosting. All you need to do is sign up for an Office Pro plan with MS Access and Outlook to try it free for 30 days.
Running your Access application on the Kindle Fire can be accomplished in just a few simple steps.
Here’s what to do:
1. Download the Microsoft Remote Desktop APK and move it over to the Kindle Fire via USB or emailing it to yourself. Note that this is a zip file and you will need to unzip it before moving it over.
2. Change your default Android Kindle settings to allow This is known as “sideloading” your application into Android. You may need to setup the Kindle to accept unknown applicaitons first by doing this:
Click your settings tab
Navigate to Applications
and allow applications to be installed from unknown sources (set to On)
3. Install the Microsoft Remote Desktop application to your Kindle. You can do this by navigating to your Downloads folder (if you emailed it to yourself) or the folder that you placed it in via your USB connection. We’ve found the free ES File Explorer app to be incredible helpful way to browse your Kindle’s Harddrive.
3. Pin the newly installed Microsoft Remote Desktop application to your home screen
5. Connect the Remote Desktop and run your Access application. Our Remote Desktop Hosting Service is available for Access 2007/2010/2013 and the Access 2010/2013 Runtime
This new version of the Remote Desktop client supports all of the Kindle gestures and features easy to navigate keyboard and mouse touch screen equivalents. Your users will find that the Access .mdb and .accdb applications they know and love work just fine on the Android Kindle Fire Tablet.
Access Hosting is proud to announce our new Excel Power Business Intelligence Hosting for only $99/month. This new plan combines the flexibility of our Remote Desktop hosting solutions with the power of SQL server hosting. This powerful solution is possible NOW without the expense of Office 365 or a SharePoint server and allows for substantial business insights through PowerPivot and Power View.
Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting. Power View is a powerful feature of Microsoft Excel 2013 that can be utilized in ANY HTML5 compatible web browser with our Power RDP technology.
Absolutely! you can user our Virtual Remote Desktop hosting on your Mac and a slew of other devices. Windows PCs come with the Remote Desktop Protocol preinstalled and if you have a Mac with Office, you’ll have RDP installed already.
We are happy to announce that our Remote Desktop Virtual Machine has undergone some price changes and is now cheaper than ever. Our RDP Virtual Appliance is only $299/month and comes with 4GB of RAM and up to 10 users. Access 2010 or Access 2007 will come pre-installed on every remote desktop. With RDP, there are absolutely NO CHANGES necessary to your Access Application to get it running in the cloud. Simply copy/paste it over to your Remote Virtual Desktop.
Additional users are now only $10 per month! and the entire Microsoft Office suite (Word, Excel, Outlook, and Powerpoint) can be added to any virtual desktop for only $10 per user per month! These plans come with No setup fee and NO long term commitment. Best of all, you can install your own software and completely customize your RDP environment.
This video tutorial answers the common question that we get about printing from a Remote Desktop hosting session. In this example, we print from Microsoft Access 2007 to a PDF file which we can then copy/paste and download to our local desktop computer so that we can print to any locally connected printers or network printers.
This video introduces you to our Remote Desktop Hosting service. It shows you how easy it is to get started using RDP hosting with our free trial and how to easily copy/paste your local Access database up into the cloud.