I've got a very large spreadsheet. I would like to email the named area "Tom" to Tom's email address and the named area "Betty" to Betty's email address and the area named "Elvis" to Elvis' email etc. etc.

You get the idea. Can that be done?