xmailbody

  1. G

    Macro that emails a list of tasks due today

    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...
  2. S

    VBA Macro help

    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...
  3. S

    VBA Code currently showing input box to select cells. I want to pre set the cells and bypass the input box.

    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...
  4. A

    Sending multiple emails through excel

    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)...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top