Few Important Steps to know How to Integrate Microsoft Access and Outlook 2007

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.

Integrate Microsoft Access and Outlook 2007

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.

How to Apply Word as Default Email Editor in Outlook

I am sharing in this post to know how you can apply Word as default email editor in Microsoft Outlook. Word has advance editing feature because that it is possible that you may want use Word as your MS Outlook default email editor.

You can also use plain text HTML format text too. It is important that the recipient must have Outlook email client and using it to read the email communication. You can easily use dictionary and other special feature in your outlook email once you apply Word as default email editor in Outlook.

You can apply the following steps to apply Word as Default Email Editor in Outlook
To set Word as the default editor for email messages in Outlook:

• Select Tools | Options from the menu in Outlook.
• Click on the Mail Format tab.
• Make sure the Use Microsoft Office Word 2003 to edit e-mail messages checkbox is selected.
• In versions before Outlook 2003, the text reads Use Microsoft Word to edit e-mail messages.
• Close the dialog.

This way you can apply Word as default email editor to your MS outlook.  MS Outlook 2007 and 2010 always use Word for editing.