All articles with 'email' Tag

Send mails using Excel VBA and Outlook

Published on Apr 23, 2012 in Automation, Excel Howtos, Learn Excel, VBA Macros
Send mails using Excel VBA and Outlook

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]

Published on Jan 19, 2010 in Learn Excel
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 »

Email marketing is NOT distributing pamphlets

Published on Jun 4, 2008 in advertising, business, ideas, India, wonder why

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 »