It’s obvious some patients with herpes are being enslaved to the antiviral and other supplementary Orthodox medicine just to help suppress the virus and not a cure. I have been with the virus since 2016 until I was introduced by a blogger who also narrated her story online on how she was cured of Genital Herpes after using Dr Noah Herbal Medicine. This is a year and 2 weeks since I was delivered from genital Herpes. All thanks to God for using this Great herbalist to heal me. I have promised to keep telling good things about Dr Noah. Please feel free to share Your problems with him and don’t forget to tell him I did refer you to Him. Thanks. Write him on mail (dr.noahmedicalcenter@gmail.com) He deals with Alzheimer virus, Cancer, HIV, Herpes, Genital, warts, ALS, BV, UTI, Virginal infection, Genital, Wart, HPV, Hepatitis A/B, Good luck, HSV, Pregnancy ...

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