Showing posts with label MS Outlook. Show all posts
Showing posts with label MS Outlook. Show all posts

Sep 10, 2012

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.

Jun 28, 2012

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.

Jun 25, 2012

How to Setup Email in MS Outlook?


You must be thinking to setup Email in MS Outlook is very difficult or complicated task. You may have tried and got success but sometime it is hard to setup email in MS outlook and you never find even a single email in your Outlook Email Account. I am sharing something important with you to know how you can do it yourself to setup email in Outlook.

I am assuming that you are already aware of Outlook Express; furthermore Outlook is similar to Outlook Express.

Do It Yourself (DIY)
You can try the following to Setup Email:
Go to 'Tools' -> 'Email Accounts' -> 'Add a new e-mail account' -> 'POP3'
User Information:
Your Name: [as you wish]
E-mail address: [you@yourdomain.com]
Server Information:
Incoming mail server (POP3): yourdomain.com
Outgoing mail server (SMTP): yourdomain.com or your ISPs SMTP Server settings.
Logon Information:
User Name: [full email address (example: you@yourdomain.com)]
Password: [email account password]
Log on using Secure Password Authentication (SPA) is NOT checked.
Click 'More Settings ...' -> 'Outgoing Server' Tab.
'My outgoing server (SMTP) requires authentication' IS checked.
(use same settings as...) is checked. (NOTE: not all ISP allow you to use SMTP servers that are not their own, so you may be required to use the settings for sending email they provide.)
Click 'OK' and you're finished.
If you want the port settings for the advanced tab in the settings, the standard ports are usually already filled in and work fine without changes; port 25 for SMTP, port 110 for POP, port 143 for IMAP. Your server may also have an alternate port 26 or 587 open for SMTP if your ISP blocks port 25.

This way you can DO It Yourself to Setup Emails in MSOutlook. Hopefully you will find this post useful and share your comments too.

Jun 4, 2012

How to Get Rid of Tiny Font While Reading Mail in MS Outlook

Continuously working on long hours on monitors can give trouble to your eyes and you may want to see the large font instead of reading tiny font in Outlook mail. It is always good to keep readable font size.
If you are facing Tiny font uncomfortable to read your outlook emails, then you can try these step to increase the Font Size While Reading Mail in MS Outlook

To read mail in a larger font in Outlook:

• Hold down Ctrl while turning the scroll wheel on your mouse down.
In Outlook 2007 and later, alternatively
• Open the message in its own window.
• Click Other Actions.
• Select Zoom... from the menu.
• Choose the desired zoom level.
• Click OK.
Outlook will not remember the zoom level.
As an alternative to the mouse in Outlook 2000-2003, you can also
• open the message in its own window and
• Select View | Text Size and the desired size from the menu.
Since this does not work with plain text emails (the mouse wheel does), also select Tools | Options... from the menu, go to the Mail Format tab, click Fonts... and use the Choose Font... button under When composing and reading plain text: to choose a bigger font.

Hope this way you find great help to get rid of tiny font while reading mail in outlook. Please keep your valuable comment here too.