xmailbody

I'm starting to learn VBA. I've got a list of tasks that are due on various days. They are divided and organized by different departments. What I need to do is scan through the whole range of dates and then automatically send an email with the tasks that are due today. I found some VBA...

Hi All, I am using the following Macro to check due dates and create and send emails based on due dates. I am in need of one last piece to finalize this, and that would be: if range is "complete" do next row. That meaning if the task is complete, it would skip that row and go to the next task...

Help would be much appreciated. VBA Code currently has input box to select cells. I want to pre-set the cells and bypass the input box so when I open the document it automatically looks at the cells. Code is as per below: Private Sub Workbook_Open() 'Updated by Extendoffice 2017/9/14 'Exit...

I have this VBA script: Private Sub sendEmail_Click() 'Updated by Extendoffice 2017/9/14 Dim xOutApp As Object Dim xOutMail As Object Dim xMailBody As String On Error Resume Next Set xOutApp = CreateObject("Outlook.Application") Set xOutMail = xOutApp.CreateItem(0)...