Sending one email for multiple items on same due date

Topic

New Reply

I am not sure if this has been posted yet but I am running into a problem with my code, I know how to write it out so that i can find and send emails when the due date is near. However now I am trying to reduce that if multiple rows share the same due date if I am able to create just one big email stating what is due? It’s a equipment inventory list with the equipment listed in column (A6:A47) and the calibration due dates listed in column (E6:E47). Also is there a way to skip row if there is no date entered in the due date? I keep getting an error. Thanks for your help

Reply | Quote