Tickler file that interacts with excel

0

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.

Answer
Discuss

Answers

0
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
        .Send
    End With

Next xCell

Set OL = Nothing

End Sub

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

Discuss

Discussion

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