hello.
I am a Business Development Coordinator within Scottish Prison Service. i am currently working on a vehicle information dashboard using excel. in the data for the dashboard it tells us when someone's business insurance is due to expire and show up a "NO" in the cell next to the date if it has expired. currently we need to look at this and e-mail each individual person corresponding to the "NO" comment, but this takes a lot of time. i have look around the internet and compiled some bits of code together that works for what i want it do to in a sense, The only problem i have is when it shows up that there is more than one person showing up as NO business insurance then it will send an e-mail to the very last e-mail address that corresponds to it rather than sending one to all of the e-mail addresses that needs it. currently i have the e-mail address in cell "D" and i have the "NO" for business insurance in cell "R" i was wondering if someone could help ? i have attached some test data for you all to see.
Thank you
Bookmarks