Hello everyone, I found a macro on a previous topic, but I am very new to excel and was unable to incorporate it into the excel file I needed to use.

In the image I've attached, I need the macro to send e-mails 10 days before the dates for column 3 in the pivot table. For example column 3's first date is 2/21/2015, so I need an e-mail to be sent on 2/11/2015. I'm using the macro that's in the image, but it's not giving me anything. I've enabled security settings and saved the file as macro enable file to see if it will work, it did not. I was wondering if anyone can tell me what's wrong with the macro that's in the image and help me fix it? Maybe because this is a pivot table that the macro isn't working?

Thank you so much!

image001.png