Sir, Thank you very much. it works wonderfully. I was annoyed by this problem. Thanx a lot.

I'm getting an error

Is there a way to keep the header across all worksheet? 

Is there a way to use the third column data to search in and still return the first two columns?

Hey! This is super quick and thanks

Thank you for the above code. I'm just curious. To add a selected range of a specific worksheet too in the body of the email. I have tried using sh.range select method in your code and the email goes out but without the range probably I'm doing something wrong here or missed to add some additional codes.

Really helpful to extract emails in a neat way, thank you!

If you change

If you change
xIndex = InStr(xFileName, ".") + 1

This is amazing. Thank you!