This post will help you to know that how you can integrate MS Access with MS Outlook 2007. I have found this feature of MS Access very useful so I am sharing it.
The benefit of integrating MS Access and MS Outlook is really great. You can easily collect the various information from various Outlook email client user and maintain the data in Excel sheet. Sometime when you have to take input on same topic from many user and you are running short of time. In such condition, I believe this integration is really meaningful.
Let us read how we can integrate MS Access and MS Outlook without even having the sound knowledge of both. As we know MS Access is Database and MS Outlook is Email client so to collect the information at one location we need to integrate MS Access and MS Outlook both.
First make sure that MS Outlook is properly configure and working fine. You are able to send/receive email without any problem. Once you have confirmed that MS Outlook is running fine then check the MS Access too.
The steps to Integrate Microsoft Access and Outlook 2007 are as follows:
Step1: Open MS Access > Go to Sample > Create Database of your choice
Step 2: Enable the Security Option too.
Step 3: Create Database as per the required filed
Step 4: Once Database filed created than save the file
Step 5: Go to > External Data > Select Create Email Option
Step 6: Click NEXT > and Choose > HTML Form Option
Step 7: Select the Fields you want to include in MS Outlook Email
Step 8: Click Next
Step 9: Don’t forget to check the option ‘Automatically Process Replies’ > Next
Step 10: Enter the desire email address [Make sure the addressee must have MS Outlook on that email id]
Step 11: Create the Email Message and MS Outlook window will Pop up
Step 12: Just send that message to desired email id
Step 13: The recipient of the message will fill the required information and reply to you
Step 14: Check your MS Outlook mail and open that reply mail
Step 15: Go to MS Access Database and just refresh the table
Step 16: You will see the updated Excel table with new data which received by Ms Outlook Email.
It is really an efficient way to work smartly when we have to collect huge amount of same information from different user in short span of time. In case if you face any trouble in the process feel free comment or write for solution.
 |
| Integrate Microsoft Access and Outlook 2007 |
Let us read how we can integrate MS Access and MS Outlook without even having the sound knowledge of both. As we know MS Access is Database and MS Outlook is Email client so to collect the information at one location we need to integrate MS Access and MS Outlook both.
First make sure that MS Outlook is properly configure and working fine. You are able to send/receive email without any problem. Once you have confirmed that MS Outlook is running fine then check the MS Access too.
The steps to Integrate Microsoft Access and Outlook 2007 are as follows:
Step1: Open MS Access > Go to Sample > Create Database of your choice
Step 2: Enable the Security Option too.
Step 3: Create Database as per the required filed
Step 4: Once Database filed created than save the file
Step 5: Go to > External Data > Select Create Email Option
Step 6: Click NEXT > and Choose > HTML Form Option
Step 7: Select the Fields you want to include in MS Outlook Email
Step 8: Click Next
Step 9: Don’t forget to check the option ‘Automatically Process Replies’ > Next
Step 10: Enter the desire email address [Make sure the addressee must have MS Outlook on that email id]
Step 11: Create the Email Message and MS Outlook window will Pop up
Step 12: Just send that message to desired email id
Step 13: The recipient of the message will fill the required information and reply to you
Step 14: Check your MS Outlook mail and open that reply mail
Step 15: Go to MS Access Database and just refresh the table
Step 16: You will see the updated Excel table with new data which received by Ms Outlook Email.
It is really an efficient way to work smartly when we have to collect huge amount of same information from different user in short span of time. In case if you face any trouble in the process feel free comment or write for solution.
