sending rows with Down status thru email to one person

[Rose Mendoza]

Good afternoon everyone.

I am currently formulating a file sending rows with down status to one person.
I used the sample from Sir Ron De Bruin, but the the auto email used to based in column B where need to input email address.
This is the first time I use the macro in excel.

i have attached the sample file that I am now formulating.


I need your help very badly.
thank you all in advance.

[jaslake]

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.

[Rose Mendoza]

Sir,
Sorry for the late reply.

Thank you for the help, really helps me a lot.

Rose

[Rose Mendoza]

Sir,
I would like to ask your assistance on the same excel file.
Using the same file, I would like to add in the last column the date and time when the file was sent thru email.
Thank you in advance for the help