Edit Existing VBA Code To Send Out Email Confirming Receipt To Suppliers

Hi All,

I have a partially working spreadsheet (i intentionally ensure all features only work in June worksheet for testing purposes) which contains two email notifications. One for my employees reminding them of their due dates to complete their task and the other confirming to my suppliers that we have received their requests.

The issue I am having is with the latter email. The email is generated (by clicking on the "Send Confirmation Receipt" button found in Email worksheet) and I managed to send it out. However, on the following day; when I generate new email notifications to my other suppliers, the previous ones are regenerated as well.

It would be greatly appreciative if someone can assist in amending the existing code to read a new column i have created, Column X, where the code would only generate emails when it sees a "YES". The email addresses are inputted manually in Column V. The existing code is the following:

Please Login or Register  to view this content.

I believe adding the column with a yes or no should resolve the issue since this is used in my employee reminders and it works perfectly.

Please find attached a copy of the spreadsheet in question. As noted previously, I am only using June worksheet for testing purposes with the required contents to generate these emails.

Try this one.

hoofbeat, please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

You're welcome.