May 26th, 2022

VBA 2010 – 061: Sending Emails

How to send emails from with VBA in Excel. You will need to have Outlook set up in order to use this code.

Download the samples for this series for free!

All our tutorial samples are free however if you appreciate our work and would like to make a voluntary donation then please do.

Recommended Reading

Both the below books by John Walkenbach are fantastic books and he is a brilliant author, I would recommend picking one of these books up even if just for a reference. I have read power programming cover to cover and it is easy to follow and is a must have for any serious VBA programmer.

If you have read any books and feel they are worth recommending then please post about them on our Forum.

VBA 2010 – 060: List Box

VBA 2010 – 062: Emails with Attachments


  1. Scott
    October 5, 2014

    I’m trying to setup a form for work where you enter information into the text boxes and then you it the command button to send an email to an email address. The body needs to reference the text boxes, how do I do that? Example of the body of the email would be: “I’ve tried to contact you ‘x amount of times’ on ‘contact number’ but have been unable to get a hold of you. Please contact us on XXX”. The ” parts need to pull in the information that are entered into the text boxes.

  2. Manjunath prasad B G
    April 13, 2015

    It is awesome…. Your work is Noble… I would recommend this to my friends and to my peers..


Leave a comment

Your email address will not be published. Required fields are marked *