Greetings all.
I've done a search on this, but the one that best describes how to do this was a bit over my head, to be honest... I know my way around Excel to do most of the basics. I can even use macros! Well, sometimes...
Anyway, I've attached the spreadsheet I need help with. I am starting up a database of companies that work for us. This database will contain all the details of the companies, their contacts, addresses, emails etc. Column O of the spreadsheet (Insurance expiry date) is the one I need the help with. In each of the cells under column O there will be a date entered manually. I'd like the spreadsheet to email 3 different addresses (if possible) when this date is within 10 days of expiry.
Because I'm not too good with Visual Basic or how code works, I'm after an idiot's guide as to how I might go about doing this. I've seen that other people have solved this problem, it's just that the steps that they've followed are beyond a mere mortal like me.
Any help or suggestions will be gratefully received.
Ron
Bookmarks