How to send email reminder automatically from Excel Worksheet using VBA




About this tutorial:

Video duration: 16:48
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
For VBA details:
In this video you learn how to use the speak cells feature in VBA and how to send an email reminder automatically from an Excel Worksheet using VBA.
Get the book Excel 2016 Power Programming with VBA:
If you are from India you can get this book here:

Incoming search terms:

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

42 thoughts on “How to send email reminder automatically from Excel Worksheet using VBA

    Naveed Akhtar

    (November 10, 2018 - 6:01 pm)

    i have a record on sheet1 and i want to copy this record to sheet 2 with match the student record and find the April fee and paste the April cell of April and find the may fee and paste the may cell accordinglly

    kurban ali

    (November 10, 2018 - 6:01 pm)

    Good evening sir
    I am watching your all YouTube videos which one is too useful for me. For send reminder mail from Excel through out can be any other email. Like I have a two email in the same company one is only for me another one is group email, so I want to use my group email. How to do that.

    Ammar Tineh

    (November 10, 2018 - 6:01 pm)

    I set up my due date to display only if a payment isnt received but the code will send an email to the receipent whose paid already … Anyways around this ?

    Gowtham Muthyal

    (November 10, 2018 - 6:01 pm)

    Sir, I need to know, how to send the reminder message to the mobile numbers automatically based on expiration date

    Runnel Mendoza

    (November 10, 2018 - 6:01 pm)

    Hi Dinesh, I tried the code but it only works on the first line email, meaning it doesn't send email to succeeding lines (with Send Reminder text)… please help

    santosh lepak

    (November 10, 2018 - 6:01 pm)

    HI, i am watching your videos from long time but however i need a help, i need to develop a excel/ VBA like we have a data which contains email id and birthday and work anniversy dates when ever we click on run it should automatically collect today birthday and anniversy people and send an automated email to them can any one help me

    nikhil kumar mamadala

    (November 10, 2018 - 6:01 pm)

    getting runtime error

    Gabrielle Chapdelaine

    (November 10, 2018 - 6:01 pm)

    Thanks for the Tuto, I have a question, is it possible that the Send email reminder work even if excel worsheet is close ? Or do we have to always have excel open ? If yes, how can we force excel to be open every time we open the computer ?

    saif hasan

    (November 10, 2018 - 6:01 pm)

    Dear Sir, your videos are helpful indeed, can you pls let me know if you have any video on how to create a code for the command button to send mail reminder automatically using VBA ? I presume it should be the one prior to this video but I’ve searched a lot but couldn’t find it, need your help pls.

    Ashley Balboa

    (November 10, 2018 - 6:01 pm)

    How do I get to the design mode on excel

    Jane McElhannon

    (November 10, 2018 - 6:01 pm)

    How do you insert the Mail Reminder button

    Emir Gökbudak

    (November 10, 2018 - 6:01 pm)

    Mr. Takyar it is really enjoyable to be your student. Thanks for every information piece that you download to web.

    The1ShyButterfly

    (November 10, 2018 - 6:01 pm)

    Hi, thank you VERY much for your tutorials, they are excellent! !!! I was wondering if it was possible to set up a reminder from the workbook even if the workbook is closed, based on a column called REMIND and if the date in that column matches today's date… that Excel will generate an Outlook email for any entries that match the date?

    SCK

    (November 10, 2018 - 6:01 pm)

    Thanks for this training video; one question : If I would like to write to mail body as " Your credit card no : ……………………………………. payment is due" ; In that case how can I add the credit card number cell information to " .body = " function?In this sample we are writing only a solid sentence.. but I would like to add some more informations which can be read from excel file also.Thanks for help from now on.

    Bibin Nath

    (November 10, 2018 - 6:01 pm)

    Great piece of knowledge.. thank you very much for this..

    kurban ali

    (November 10, 2018 - 6:01 pm)

    I create one payment reminder notification in excel and also add mail ID for send mail reminder notification, now I want to know how to remove highlight mark from excel sheet automatically and expired mark also can you suggest me for that.

    kurban ali

    (November 10, 2018 - 6:01 pm)

    I make it reminder and send maill also, onec i got the payment how to remove highlight mark from excle autometecally

    Pramod

    (November 10, 2018 - 6:01 pm)

    I have msg91 login & plugin can i send sms insted of mail

    Arvind Kumar

    (November 10, 2018 - 6:01 pm)

    Hi sir thanks for support , sir one thing is that i want to know how i set mail body through selection of excel cells range

    Abdul Matin

    (November 10, 2018 - 6:01 pm)

    Dear Sir, Thanks for your Excellent tutorial. Please provide Data Accumulator using excel VBA

    Shashikala Gangappa

    (November 10, 2018 - 6:01 pm)

    comment we have typed in excel row & column. This data should go as a body of a texture through outlook. Please help me on this

    Shashikala Gangappa

    (November 10, 2018 - 6:01 pm)

    hello sir
    comment we have typed in excel row & column. This data should go as a body of a texture. Please help me on this

    AL Naseri

    (November 10, 2018 - 6:01 pm)

    For those who have an issue with RUN TIME ERROR -424: OBJECT REQUIRED, if you copy the code from the website, you need to replace all quotation marks. mean delete them and put them back by using your keyboard, then you will see they look different.

    Luz M

    (November 10, 2018 - 6:01 pm)

    How could I change the coding to only send the email to one person? I did follow your steps and I ran into an error message, "We need to know who to send this to. Make sure you enter at least one name." Please assist!

    DreamBoy

    (November 10, 2018 - 6:01 pm)

    Hello Sir…Great Video. How do I get the image also in mail body. Please help me

    Dim mydate1 As Date
    Dim mydate2 As Long
    Dim datetoday1 As Date
    Dim datetoday2 As Long

    Dim x As Long
    lastrow = Sheets("Mail").Cells(Rows.Count, 1).End(xlUp).Row
    For x = 2 To lastrow

    mydate1 = Cells(x, 6).Value
    mydate2 = mydate1

    Cells(x, 9).Value = mydate2

    datetoday1 = Date
    datetoday2 = datetoday1

    Cells(x, 10).Value = datetoday2

    If mydate2 – datetoday2 = 0 Then

    Cells(x, 7) = "Yes"
    Cells(x, 7).Interior.ColorIndex = 3
    Cells(x, 7).Font.ColorIndex = 2
    Cells(x, 7).Font.Bold = True
    Cells(x, 8).Value = mydate2 – datetoday2
    End If
    Next
    End Sub

    Katherina Mavraganis

    (November 10, 2018 - 6:01 pm)

    I use a Mac and I have 2016 excel. Under developer tab there is not a design mode. Is there any other way I can do it?

    Katherina Mavraganis

    (November 10, 2018 - 6:01 pm)

    Also cannot find design mode

    Katherina Mavraganis

    (November 10, 2018 - 6:01 pm)

    Hi thanks, I followed all the steps until send reminder. Where can I find mail reminder on excel 2016? I cannot find it.

    TongServo

    (November 10, 2018 - 6:01 pm)

    Hi.Team Please Show full code Sheet1 ,help me

    Mayur Patel

    (November 10, 2018 - 6:01 pm)

    I will enter data in every 10 days.I want to set upcoming specified date after no of day.if i enter data every day then this formula can be work=TODAY()+B1 where B1 is Project duration.
    For an example:- Today date is 04/07/2017, data enter date also same 04/07/2017.

    date Project duration in day
    28/06/2017 17
    30/06/2017 5
    01/07/2017 3
    04/07/2017 2
    Can you help me to solve out problem

    prabagaran achannan

    (November 10, 2018 - 6:01 pm)

    i tried the codes but it keep telling me to give a name to send to, when debug keep pointing and .send , could you help me on this ?

    Akshay Khot

    (November 10, 2018 - 6:01 pm)

    SIr, Can you please brief about the code if i want to mention the specific cell values in the body of the mail. Eg. all Credit card numbers in this case shuld appear in the mail body.

    Maddy Mad

    (November 10, 2018 - 6:01 pm)

    hi it is just sending to the first email address please advise

    Raushan Raj

    (November 10, 2018 - 6:01 pm)

    I have an excel file in which multiple sheets are present. From "Sheet1", I have to look for a character "d" in column "M". If "d" is present in column "M", then I have to copy the row contents (cells A-H) where the character is found to a new sheet "Sheet2" and send the reminder to mail address with the contents of "Sheet2" through Microsoft Outlook

    fried rice

    (November 10, 2018 - 6:01 pm)

    Sir how to send message from excel 2013 to mobile numbers

    Bhabani Mallick

    (November 10, 2018 - 6:01 pm)

    WHILE RUNNING IS ASKIG FOR "RUN TIME ERROR -424: OBJECT REQUIRED. KINDLY HELP ME OUT

    Prasand Kumar

    (November 10, 2018 - 6:01 pm)

    Thanks in advance. I have an Excel application and wish to send email from within the VBA using SMTP.

    I am using Excel for Mac 2016, and therefore the Microsoft CDO method is not an option as far as I can determine.

    I do not wish to use Outlook, Mac Mail, or other email client, but rather wish to send directly from within the application.

    iyiola falade

    (November 10, 2018 - 6:01 pm)

    Hello Dinesh. Thanks for sharing your knowledge.
    Please is it posible to add an attachement to the mail intended for the Receipient.

    Soumya Kosigi

    (November 10, 2018 - 6:01 pm)

    Hello Sir…Great Video. How do I get the Mail reminder button? I am using Excel 2007. Thank you in Advance

    Richard Chen

    (November 10, 2018 - 6:01 pm)

    hi bro how did u get the mail reminder icon when clicking the designer mode? i tried several times not successful. And is it possible instead of outlook send to Gmail?

    Ameya Kale

    (November 10, 2018 - 6:01 pm)

    While running this code, I am getting an error: for .Send
    It says "Run-Time error '-1247467259 (80004005)': We need to know who to send this to. Make sure you enter at least one name."

    Can anyone help me solve this?

    Jim Sembiazza

    (November 10, 2018 - 6:01 pm)

    Again, thank you Dinesh…. I need to re-phrase my question/s:
    Is it possible to set-up (program) excel and outlook to team up to automatically send reminder emails without any human triggering based solely on dates and an email address'? If so, any chance you might already have an example video you can point me to?

Leave a Reply

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