SEND EMAIL

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 outlook. Thanks to you all for providing me the prompt feedback about the same. I have fixed it but I have not changed the version of the tool as such. It will still remain as version 4.0. This [...]

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 your friends a Happy New Year Email for this coming new year 2017? Sounds good !! but would you put every one's email in to List and send them all a generic message?? Noooo!! how about sending [...]

Image in Signature not Displayed – Mail Sent by VBA

Dear Friends, I was keep getting this question from many of you that whenever your outlook signature has an Image then rest of the texts are displayed correctly but Image was never displayed. It was always appearing with a red cross sign (missing image) image. In order to get rid of this problem there are two solutions. outlook Signature [...]

Send Image of a Range from Excel embedded in Mail [Inline Image in Mail]

Dear Friends, Couple of my friends asked me about this like how can I send screenshot of a particular range area of my excel sheet embedded in my HTML mail with other texts in my email. I also got this question on Microsoft Excel forum where I answered that question by providing a piece of code. Though there were some [...]

FREE Download : Send Multiple Email Tool – Ver 3.0

Dear Readers,   First of all, I would like to thank you all for appreciating and giving the feedback about Send Multiple Email - VBA Tool. I have come up with the next version of the same tool based on your suggestions and feedback. I promise, this version is going to amaze you with it's new properties. I would like [...]

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 request to implement many other functionality as well. Attachment was one of them. In this version I have added the attachment functionality with some other small fixes. Download the latest file from the end of this article and let me know [...]

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, then here is the code to do so.  

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

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 supports HTML formatting of the email body, it is possible [...]

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 [...]