Monthly Archives: August 2012

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. There can be two different ways of Sending a chart in email as an image via outlook. For sending a chart in email, we will first save the chart as an image in temp folder of your system. Send the Chart Picture [...]

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 by clicking on the below image:   This article [...]

By |Categories: Excel Macro|Tags: |1 Comment

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 function sends two sheets Sheet2 and Sheet3 of the current workbook [...]

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 an attachment in email. Sub Email_One_ActiveSheet() 'Do not forget to change [...]

Download Free File Manager – New Version

Hi Friends, I had created one file manager in Excel using excel macro. Basically it lists all the Files in a folder and sub-folders of any given drive in your PC. It fetches File Name, File Path, File Size, File Type, Last Modified Date of each file and list it in the Excel. Based on some valuable inputs and queries, [...]