+ Reply to Thread
Results 1 to 4 of 4

Excel to send Email automatically when due date is approaching

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    16

    Excel to send Email automatically when due date is approaching

    I am new to macro.
    I need excel to send email AUTOMATICALLY whenever the due date is approaching. (Example about 10 days before)
    And the email subject and body should be taken from the excel sheet.
    Besides that, can it trigger multiple email? (Maybe two email send to the same person, as both task are due)
    The Workbook has the sample in it. please take a look.
    Appreciate every single help. Thanks in advance.
    Attached Files Attached Files
    Last edited by EugeneE; 04-23-2013 at 11:35 PM.

  2. #2
    Registered User
    Join Date
    04-22-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Excel to send Email automatically when due date is approaching

    Anyone???????

  3. #3
    Registered User
    Join Date
    12-05-2012
    Location
    Crewe, Cheshire, UK
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Excel to send Email automatically when due date is approaching

    Not good news for Excel, but I use www.smartsheet.com for this sort of task. It works very like a cloud based excel sheet, but has a powerful alerts function etc. etc.

  4. #4
    Registered User
    Join Date
    04-25-2013
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Excel to send Email automatically when due date is approaching

    Similar problem

    Can someone help with resolving the deferreddeliverytime function. Sending immediately and no delay unless I reference only one cell.

    The task is this: I need to send emails of detailed information to teachers on particular dates, such as notices and activity rosters. I would like to delay sending the information for various reasons and keep the mails in my outbox until a future date. My columns are as follows: Col 1 is email, column 2 is the subject, col 3 body, col 4 attachement, column 5 schedule that is the delayed I have placed the delayed dates in column 5. The problem is that the emails are sent out immediately and not delayed.

    Dim OutlookApp As Object
    Dim MItem As Object
    Dim cell As Range
    Dim email_ As String
    Dim subject_ As String
    Dim body_ As String
    Dim attach_ As String
    Dim DateSend_ As String

    'Create Outlook object
    Set OutlookApp = CreateObject("Outlook.Application")

    'Loop through the rows
    For Each cell In Columns("a").Cells.SpecialCells(xlCellTypeConstants)

    email_ = cell.Value
    subject_ = cell.Offset(0, 1).Value
    body_ = cell.Offset(0, 2).Value
    attach_ = cell.Offset(0, 3).Value
    DateSend_ = cell.Offset(0, 4).Value

    'Create Mail Item and send it
    Set MItem = OutlookApp.CreateItem(0)
    With MItem
    .To = email_
    .Subject = subject_
    .Body = body_
    .Attachment = "attach_"
    DateSend_ = cell.Offest(0,4).Value
    ‘Delay send
    .DeferredDeliveryTime = DateSend_
    MItem.Send

    End With


    Next

    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1