Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 34

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

  1. #11
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    The working draft version is ready. Test this please.
    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. #12
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0
    Excel Fox, thank you so much. I will try it tomorrow. Please pm me your paypal so I can send payment. If there is anything that needs to be changed, I will let you know. Thanks!

  3. #13
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Please test the file and let me know if it's fine. Will share payment detail after that.
    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. #14
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0
    Ok. Here are a few things that needs to be corrected. The email should be sent to the interpreter, in column I. The client name should be referenced so the interpreter will know who they will be interpreting for.

    For example, right now the email says: Dear Thomas Jefferson, you have a meeting scheduled. Please find details below: Time and date of appointment: 5 December 2014, 12:15am. Venue: 1234 street ABCD avenue, seattle, wa 12345.

    It should say: Dear Pam Doe, you have an appointment scheduled. Please find details below: Client: Thomas Jefferson. Time and date of appointment: 5 December 2014, 12:15am. Venue: 1234 street ABCD avenue, seattle, wa 12345.

    Also, our department has a department email, 'interpreters@whatever.com'. Is there a way to have that address send the email? That way when the interpreters email back it goes into the department inbox and the other staff members can see the email instead of it sending it to my own inbox where only I can see it.

    I've noticed that the email is sent 24 hours in advance, therefore the macro is running basically a couple times an hour throughout the day. Can we just have it send an email at the beginning of the day for all of tomorrow's appointment regardless of time?

    Thanks in advance, Excel Fox, you've been great.

  5. #15
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Made the modification. Code is ready. Will send payment details. Once payment is done, I will post the file here.
    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

  6. #16
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    By the way, to be able to send from another account, you'll need to have access to that. In other words, you should be able to do this manually, for this to work using VBA.
    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

  7. #17
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0
    Great. Please PM your paypal acct. Thanks!

  8. #18
    Junior Member
    Join Date
    Nov 2014
    Posts
    17
    Rep Power
    0
    PayPal sent. Thanks

  9. #19
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Will send the code and file right away
    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. #20
    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

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
  •