200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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.
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 SubIt's from the second link above, which provides more information on the macro.