How to Send a HTML Email using Word Email Template using Excel Macro Hi All, This is my very first post for learnexcelmacro.com. Thanks to Vishwa for roping me in for this good cause. Your Help/ comments / suggestions for improving this better. Things Needed:...
Results for "excel"
Download : Excel Macro Application to Send Multiple Emails – 2.0
Hello Friends, I got many good response on the tool - Send Multiple Email Workbook. I also got a request to implement much other functionality as well. The attachment was one of them. In this version, I have added the attachment functionality with some other small...
How to Export an Excel Sheet as PDF file
Dear Readers, In this article you are going to learn How to save an Excel Sheet as pdf file. Many a times we generate certain reports in an Excel Sheet but while sending that report to your boss, you want that to be saved in a PDF form. In such case you can simply...
How to display Input message on selecting a cell in Excel
Dear Friends, In this article I am going to explain you.. How you can display a message as soon as on selecting a cell. Most importantly here you need not write any VBA code to do so. When I say it is an input message, it is not a message box or input message box. It...
How to insert Outlook Signature in Email by Excel VBA
In this Article you are going to learn how to insert Outlook Signature in outlook email while sending an email via Excel VBA. It means while sending an email from Outlook via Excel Macro, if you want already saved signature to be inserted at the end of your email,...
Excel Formula : MATHEMATICAL Formulas
Want to know about most of the Important Formulas in Excel? Read Excel Formulas Tutorial Page. Click on the below links for to know about all these Formulas and how to use them ABS | CEILING | COMBIN | COUNTIF | EVEN | FACT | FLOOR | INT | MINVERSE | MMULT |...
Excel Formula : DATE and TIME Formula
Want to know about most of the Important Formulas in Excel? Read Excel Formulas Tutorial Page. Click on the below links for to know about all these Formulas and how to use them DATE | DATEDIF | DATEVALUE | DAY | DAYS360 | HOUR | MINUTE | MONTH | NOW | SECOND |...
What is Excel Formula ? How to use Excel Formula?
This Article is written for the people who does not know about Excel formula. This article answers following questions about Excel Formulas: 1. What is Excel Formula? 2. How to Use Excel Formula - a step by step tutorial. 3. How an Excel Formula works in Excel?...
Allow Cell Drag and Drop Option in Excel 2003, 2007 and 2010
Hi Friends, Before I go and explain you how to enable or disable drag and drop option in Excel, let me explain you what is Drag and Drop Option in Excel. What is Drag and Drop Option in Excel ? When you select a Cell in Excel and roll your mouse to the Right-Bottom...
How to Send Email Automatically from Excel
Hello friends, In the previous Article, you learnt how to Schedule a Program in Windows. In this article you are going to learn, How can we send emails from Excel on a Scheduled date and Time automatically without any manual intervention. I have taken an Example from...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
5 very useful and small macros
In the first part of this article, I am going to share very small but useful VBA codes which are most frequently used...
Assign a Hot Key to a Command Button in Excel
In Excel VBA you can assign a hot key for a command Button as well. It means you can assign a hot key to a command...
Assign a Shortcut Key using Excel VBA
Dear LEM Readers, In the previous article, you learnt how to assign or modify a shortcut key using excel...