Saturday, April 19, 2014

How to Import Yahoo Mail Contact in Outlook

There are numerous web-based email services to choose from, and as new ones pop up or start to gain new features it is quite common to find that you want to move from one to another. If you have been lured by Outlook.com but have been reluctant to leave behind your Yahoo account, for instance, Microsoft just made things a whole lot easier. It’s now possible to import your Yahoo account into Outlook.com so you can keep all of your old messages while taking advantage of Microsoft’s advanced email service.
Making the import is pretty simple. Start by logging into your Outlook.com account, click the gear icon to the upper right hand side of the page and select Options from the menu. In the Manage your account section, click the Import email accounts link.
You’ll see that there is an entry labelled Yahoo, and if you click this you will be prompted to enter your Yahoo username and password. Enter your login details and click Import.
import_yahoo_1
You will have to wait for a few minutes while all of your emails are imported, but you can continue to use Outlook.com for other things in the meantime.
Once the import is complete, you’ll not only have access to all of your old emails, but you will also be able to continue to send emails via that old address through Outlook.com — a great help in making the transition.

How to Activate Airtel Voicemail service for free on your Prepaid Mobile

Airtel provides Free Voicemail service for all prepaid customers but unfortunately no one is aware of it. Even Airtel website or customer care representative is unaware of it.
Activation by Call Code:
  • Call *321*671# for Activation
  • Call *321*673# for Deactivation
Activation by SMS Code:
  • START VMS to 54321 for Activation
  • STOP VMS to 54321 for Deactivation
Voicemail Account Management:
To access your Voicemail Account Management, call Dial 52555 from your registered Airtel Prepaid Mobile. For the very first time, it will prompt you to set a 4 digit passord. Next time you need to enter the password to access your profile settings.
With your account Management, you can do the following things
  1. Change your language presence
  2. Set your Own Custom Voicemail Message
  3. Hear, Save and Delete the received voice mail messages
  4. Change Voice mail box name
You can press the following numbers to perform action on your current running Voicemails
  • Delete – 3
  • Reply – 4
  • Save – 5
  • Previous Voicemail – 6
  • Replay Again – 7
  • Next Voicemail – 8
  • Settings – 9
Settings Page:
  • When you login to setting, Press 2 to change language presence
  • Rename Mailbox Name – 3
  • Change Password – 4
  • Hear or Change current welcome message – 7
  • Remove current Welcome Message – 8

Saturday, April 12, 2014

HOW TO SHOW BLANK CELL RED EXCEL CONDITIONAL FORMATTING






1. Select cells you want to format
2. On Home Ribbon go to Conditional Formatting --> Highlight Cells Rules --> More Rules...
3. In "New Formatting Rule" pop-up select "Format only cells that contain" option from "Select a Rule Type:" section
4. In same pop-up window select "Blanks" options from drop-down-list given under "Edit the Rule Description:" section
5. Again, in same pop-up window click "Format.." button to define type of formatting you wish and click "Ok" to close window