Page 1 of 4 123 ... LastLast
Results 1 to 10 of 34

Thread: VBA Code To Send Automatic Mail Reminder For Meeting X Days In Advance

  1. #1
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0

    Exclamation VBA Code To Send Automatic Mail Reminder For Meeting X Days In Advance

    Hi all,

    I'm looking for a macro to put into Excel that will send a reminder email to a corresponding staff member one day before the appointment. Email is through Outlook.

    Is it possible for it to automatically populate the client name, time of appointment and location in the body of the email? All information will be in the excel spreadsheet.

    I've attached an example sheet. Payment will be through PayPal. Thanks for the help in advance.
    Attached Files Attached Files
    Last edited by exceldumby; 11-23-2014 at 07:51 AM. Reason: attaching file

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Will you have Excel and Outlook open all the time? Or did you have any other idea?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0
    Yes, Excel and Outlook is open all day when I'm in the office.

    One more thing, is there a way for it to not send the email if the appointment is cancelled? Cancelled appointments are in red.

  4. #4
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    That can be done. But how does one make it red? Do you update the Excel file once you get to know it is cancelled?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  5. #5
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0
    Yes, the staff will make it red the moment we find out its cancelled.

  6. #6
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0
    Anyone? Let's up the money. $50!

  7. #7
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Will certainly work on this and get back.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  8. #8
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0
    Excel Fox, any progress?

  9. #9
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Yes. Targeting tomorrow evening for a working version
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  10. #10
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0
    Thank you so much! I'll keep an eye out

Similar Threads

  1. Replies: 1
    Last Post: 12-23-2013, 10:09 PM
  2. Replies: 1
    Last Post: 11-20-2013, 09:14 AM
  3. Auto E-mail For Due Date Reminder Using Outlook
    By samd007 in forum Excel Help
    Replies: 4
    Last Post: 09-23-2013, 02:33 PM
  4. Send Automatic Reminder Mails Row By Row Based On Status
    By amar.kshirsagar in forum Excel Help
    Replies: 4
    Last Post: 08-09-2013, 07:36 PM
  5. Replies: 11
    Last Post: 11-10-2011, 12:32 AM

Posting Permissions

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