Happy Diwali – 2012
Dear Readers, Wish u and your family a very happy Diwali and a prosperous new year. May God fulfill all your wishes in wealth, health and happiness in your life. May this festival of lights brings all happiness and prosperity in your life. Wish you a very happy Diwali
Important : Declaring multiple Variables with one Dim Statement
Hello friends, As you know in VBA variables are declared using Dim Statement. You have also learnt about how to declare a variable in VBA in the previous articles. You have also learnt about Implicit and explicit option variables. Here is a question: In...
VBA Programming : Decision – Select Case
Hello friends in the last article of VBA Programming Tutorial you have learnt the use of If..else statement. In this lesson you are going to learn another decision making statements in VBA. It means it is another way to control the flow of program, that is nothing but...
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,...
Pivot Table Tutorial : Make Pivot Table in 15 Seconds
Hi friends, In the previous article of Pivot Table, I had explained basics about Pivot table and how to make a pivot table in Excel. This is just an extension to that article. Here I have created a Shortest video to show How to create Pivot table in Excel. Watch the...
What is Pivot Table ?
As you know Excel has so many excellent features in it. Pivot Table is one of them. If you use Microsoft Excel and not used Pivot Table, It means you have missed a really great feature of Excel. Pivot table is the best tool available in Excel to Sort, Filter, Count,...
Mail Chart as Image from Outlook – VBA Code
In this article you will learn how to send a chart as picture using outlook from Excel Macro. As you know that in Outlook email, you can send an Image like a normal file attachment. In this case, receiver has to open the attachment to see the content. Since outlook...
Library not registered – Automation error
Dear Friends, I had installed Office 2007 in my system. After that I installed the trial version of Office 2013 in my system. There are so many new features in this version. Really great one. You can also try installing the trial version of Office 2013 in your system...
How to Send more than one Sheet of the workbook in mail
In previous article of Send Email Tutorial using Excel Macro, you learnt how to send One Sheet (Active Sheet) as attachment in the email. In this Article you are going to learn how to send more than one Sheet from a workbook as an attachment in Email. The below...
How to Send ActiveSheet as Attachment in mail
In previous article of Send Email Tutorial using Excel Macro, you learnt how to send current workbook as attachment in the email. In this Article you are going to learn how to send the ActiveSheet as an attachment in Email. The below function sends the active sheet as...
Buy a coffee for the author
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 (=).
Conditional Formatting based on Condition in other Cell
In previous post we saw the normal conditional Formatting. It means based on the condition of a cell, changing the...
Conditional Formatting in Excel
Conditional Formatting in Excel: In MS Excel we can do formatting of cells based on some conditions or values. This is...
Sorting a String stored in a cell of Excel
Dear Readers, By using Excel Macro, we can sort a String which is stored in a Cell in an Excel Sheet. Sorting will be...
Recommended articles
Recommended Articles
VBA to Convert Contact Data in Excel to VCF format
Dear Friends, As you have learned about interacting with Text files through Excel VBA, it is time to see the usage of...
Validate BurgerServiceNummer (BSN) using Excel VBA
Important Note: This post will make more sense to those who stay in the Netherlands. Also do not forget to download...
![Send Multiple Emails Tool – Ver 4.0 [Imp Bug fixes]](https://vmlogger.com/excel/wp-content/uploads/sites/11/2016/12/2016-12-30.png)
Send Multiple Emails Tool – Ver 4.0 [Imp Bug fixes]
Dear friends, The version of Send Multiple Emails Tool, I released last, there was a small issue with the mail sent by...
FREE Download : Send Multiple Emails Tool – Ver 4.0
Dear LEM Readers, Here I come with a new version of Send multiple Email using Excel. Are you planning to send all of...