sending rows with Down status thru email to one person

Hi Rose Mendoza

Your code in Module 6 seems to work fine except that you're getting duplicate emails to the same person. The reason this is happening is because your looping through all the filtered cells in Column B Machine Up Data. I've added code to Module 6 that creates a temporary worksheet that holds Unique Email Addresses. Machine Up Data is then filtered with these Unique addresses. This temporary worksheet is deleted when we're finished with it.

I've also moved your Range to HTML function to Module 6 so that rng definition applies to the entire Module. Let me know of issues.