I would like to email everyone in a specific column of my spreadsheet...
I've got individual cells that have the hyperlink commands to build the mailto: I also have direct entered email addresses that Excel formats correctly.
What I would like to do is select a range of cells and anything that looks like an email address in that range gets sent to my Outlook email client as email; email; email; email; in the TO field.
The trick will be that some of the email is in a hyperlink command, the others are direct.
Any ideas?
Bookmarks