Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 34

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

  1. #21
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Here's the updated file with code.
    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

  2. #22
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0
    Excel Fox, everything works great! I need something else added to the email, per my supervisor. The date of birth, column D, and the transport, column G. Could you do it where if the transport column is empty then it doesn't need to be in the email. If there is something in there, then it needs to be in the email. Thanks!
    Attached Files Attached Files

  3. #23
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Sure. Can you share the exact format of the mail for both cases
    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

  4. #24
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0
    Sure.

    Dear John Doe:

    You have an appointment scheduled. Please find details below:

    Client: William Harrison. DOB: 04/04/08
    Time and date of appointment: 13 December 2014, 9:00 AM. Venue: 5678 President Circle, Seattle, WA 12345
    Note: Please Transport

    And if column G doesn't have anything in it:

    Dear John Doe:

    You have an appointment scheduled. Please find details below:

    Client: William Harrison. DOB: 04/04/08
    Time and date of appointment: 13 December 2014, 9:00 AM. Venue: 5678 President Circle, Seattle, WA 12345
    Note:

  5. #25
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0
    Excel Fox? Any chance you had a chance to work on it?

  6. #26
    Junior Member
    Join Date
    Dec 2014
    Posts
    3
    Rep Power
    0
    Hi Excel Fox,
    if u will allow then i want to Post your file with this little part to complete the requirements.

    I have done this and file is ready with me.

    Thanks//
    Last edited by DInesh Mudgal; 12-16-2014 at 12:38 PM.

  7. #27
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Dinesh, why don't you post it here. If its in line with what exceldumby wanted, great. If not, I will finish it after exceldumby's revert
    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. #28
    Junior Member
    Join Date
    Dec 2014
    Posts
    3
    Rep Power
    0
    Using VBA To Send Automatic Meeting Reminder Mailers 1 Day In Advance_Modified.xlsm

    Thanks Excel fox,

    Hi exceldumby,
    please find attached file check and let us know if anything missing.

  9. #29
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0
    Hi DInesh,

    That macro is perfect! Everything looks great. I have another question, can I use this macro in a shared worksheet? I've tried to run the macro in a shared workbook but it doesn't do anything.

  10. #30
    Junior Member
    Join Date
    Dec 2014
    Posts
    3
    Rep Power
    0
    Hi,
    i have not tested it for that. i will try in free time. can u share error description and screenshots?

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
  •