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.
Last edited by exceldumby; 11-23-2014 at 07:51 AM. Reason: attaching file
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
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.
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
Yes, the staff will make it red the moment we find out its cancelled.
Anyone? Let's up the money. $50!
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
Excel Fox, any progress?
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
Thank you so much! I'll keep an eye out
Posting Permissions
Reply With Quote
Bookmarks