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

[hoofbeat]

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.

[bakerman2]

Try this one.

[6StringJazzer]

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

[hoofbeat]

6StringJazzer - My apologies for the oversight and thanks for editing.

bakerman2 - Thanks for your assistance. It works perfectly.

[bakerman2]

You're welcome.

[hoofbeat]

Hi All,

I would greatly appreciate some help again with the previous worksheet which was successfully fixed by bakerman2.

It works perfectly but just need some minor tweaking. Since I'm not familiar with VBA, i would greatly appreciate the following changes.

1) to change the below code which currently calculates the networkdays it takes to perform a task to exclude holidays (using Cells N3 & N4 in the worksheets as the holiday range)

Please Login or Register  to view this content.

2) Send email reminders from a general mailbox instead of from the individual sender. (ie as though messages was coming from the email address: General.Mailbox@abc.com)

and
3) the ability to insert a logo or image as a signature line.