Send auto-email reminder from excel

I'll help you first by pointing you to our tutorials that cover these topics.

First you need to get a macro to run when the cell shows the "late" value.

• Run a Macro when a User Does Something in the Worksheet in Excel
• Run a Macro When a Specific Cell Changes in Excel

Next, the email macro:

Email List of People from Excel Using a Macro

I edited the macro to work on a speicifc cell:

Sub Send_Email_to_List()

Dim OL As Object, MailSendItem As Object
Dim MsgTxt As String
Dim xCell as Range

Set OL = CreateObject("Outlook.Application")

xCell = Range("A1")

    user_email = xCell.Value
    user_subject = "Subject Line for the Email"
    user_msg = Cells(xCell.Row, 2).Value

    Set MailSendItem = OL.CreateItem(olMailItem)

    With MailSendItem
        .Subject = user_subject
        .Body = user_msg
        .To = user_email
        .Send
    End With



Set OL = Nothing

End Sub

In your case, you will probably want to pass the cell value that contains the email address to the email macro and here is a tutorial that shows you how to do that:

Pass Values from One Macro to Another Macro