Tickler file that interacts with excel


I am looking for a way to send out automatice reminders on reports that are in my excel database.

I am not sure if Excel can do that or if I need to go to an outside source. I use google mail but do not want to go in and post the due dates and want to do a sort of mail merge letter.

Your expertise is much appreciated.



Selected Answer

You need to go through Microsoft Outlook. You can setup outlook to work with gmail accounts.

We currently have 3 macros on the site that might help you:

Email Current Workbook & or Other Attachments

Email List of People from Excel Using a Macro

Send Emails through Outlook using Email Addresses from Excel and text from Word

I think this macro might be the one that you are looking for:

Sub Send_Email_to_List()

Dim OL As Object, MailSendItem As Object
Dim MsgTxt As String

Set OL = CreateObject("Outlook.Application")

For Each xCell In ActiveSheet.Range(Range("A1"), Range("A" & Rows.Count).End(xlUp))

    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
    End With

Next xCell

Set OL = Nothing

End Sub

It's from the second link above, which provides more information on the macro.



TThank you.  I will try it.  I am not good at macros, but there is no better time than the present.
Many thanks.
JayBee (rep: 2) Mar 15, '17 at 12:20 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login