200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Iam an accountant , and i have an excel sheet for bank garante letters , containing as full details for more than 50 garantes for difrent organisations , each one has specific end date ,
my question is , how can i let excel send me by mail the gurentee which need to renew before one week of its end date , and can i add more than one person at mail too..
thanks in advance
You can do all of this for sure. I am not going to whip it up from scratch for you here, but I will give you the outline of what you need and some resources.
You will need a macro that runs on a certain date and time, which is not exactly reliable since you will have to have the scheduling program open, which I assume you meant to be Excel. If there is a way to do all of this from Outlook, that might be better if you always have it open.
Once you have the scheduling part down, then all you need to do is to send the email, which is actually very easy to do if you have Excel and Outlook on the same system.
Here are some resources:
Send Emails from Excel - this includes a sample file and video tutorial.
Send Email VBA Macro - this is a sample and easy-to-understand email macro that should get you started sending emails from Excel.
