Hello Mates,

I really appreciate your support as I'm trying to use excel as task scheduler software to do the following

Send Auto notifications or reminder from MS outlook In specific date and time It could be on regular basis (recurrence) To different people each time With different subjects and message (email body) for each task

Please help

I use the below code to use excel to send through outlook

Dim olApp As Outlook.Application
Set olApp = CreateObject("Outlook.Application")

    Dim olMail As Outlook.MailItem
    Set olMail = olApp.CreateItem(olMailItem)

    olMail.To = email at example dot com
    olMail.Subject = "Excel Notification"
    olMail.Body = olMail.Body + "Dear Mr. Excel, " & vbNewLine & vbNewLine _
         & ThisJob & "Kindly update your Open Cases and followup flags." & vbNewLine & vbNewLine _
         & ThisJob & "Regards," & vbNewLine _
         & ThisJob & "MR Follow up"
    olMail.Send

       

Hi,

This is the forum to discuss questions and feedback for Microsoft Excel, your issue is related to Excel DEV, I recommend you post the question to the MSDN forum for Excel

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

George Zhao
TechNet Community Support