Send E-mail using Other account by outlook.


Sometime there are more than one account are configured in outlook and when we use VBA to send Emails, it use the default account. but in case you have to send emails through other account , you can use this code. the bold lines are telling outlook to use another account to send emails. Sub…

Convert Specific formula to value :


Many times i have seen this query on Excel discussion groups and forums to convert values for a specific formulas on worksheets. so i have decided to post a something about that. it might be little helpful for Excel users. here is a code which will convert formulas to values on every sheets, this code…