Sometimes we get error message – 530 SMTP authentication is required when attempting to send an e-mail through MS Outlook. In this article I will discuss how to resolve this error. Here I used MS Outlook 2010 1. Go to File -> Account Settings 2. Click Email Tab and double click on you email addresss
Tag: MS Office
Color a row of excel based on cell date time value (Today)
Select all rows of excel in which you want to apply formula. There must be a date time filed on which you will apply rule. Suppose, column A is date time column and it is started from A2 Conditional Formatting -> New Rule -> Use formula to determine which cell to format Write in format