All articles with 'email' Tag
Ever wondered how we can use Excel to send emails thru Outlook? In this article we well learn how to use VBA and Microsoft Outlook to send emails with your reports as attachment.
Scenario: We have an excel based reporting template. We want to update this template using VBA code to create a static version and email it to a list of people. We will define the recipient list in a separate sheet.
Read on…
Continue »Extract usernames from E-mail IDs [using LEFT and FIND formulas in Excel]
Today we will learn to use Excel’s LEFT and FIND formulas. But what fun it is to learn a new formula on a Tuesday? So, we will actually learn to use these formulas to solve the problem: “extract the username from an email ID” How is an email ID structured? Any email ID contains 2 […]
Continue »Take a look at the above screen shot of my inbox. Does any thing look odd? Of course it does, the amazing folks at IRCTC have decided to send a tempting summer vacation offer to me, not once but 5 times in the last 14 hours. Despite having one of the finest Indian online customer […]
Continue »