Hi,

I found code at Ron's Excel Tips about emails which works on an E address located in A1 of every sheet I have attached a example of how it would work for me but my only problem would be the increase areas would mean more and more Tabs.
Can this be done for match data and send to correct Distribution list?

Please don't think i'm all over the place and not sticking to my original question, i'm just trying to find code and ideas to maybe put together my request to meet my original question.

Thank you for any help


Nurofen