Email all in a Column

[bmasella]

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?

[Tarball]

From Walkenbach's book - Excel 2003 Power Programming. (If you dont have this book then you really ought to run out and buy it). Very good text. Change the logic to email from the column that contains your mail addresses. This procedure should get you started in the right direction.

Please Login or Register  to view this content.

[bmasella]

My email addresses are actually in a formula that uses a first name and last name in the prior field to "create" the hyperlink to an email address using a company standard for [email protected]

IF(H114="","",HYPERLINK(LOWER(CONCATENATE("mailto:",LEFT(H114,FIND(" ",H114,1)-1),".",RIGHT(H114,LEN(H114)-FIND(" ",H114,1)),"@companyname.com")),"[EMAIL]"))

I would like it to be everyone in a column but I don't necessarily know which column it will be... so wherever I put this button I would like it to find out what column it is in and then use that column as the column that it searches for the email addresses. For example if I place the button in column J then the script would look in column J for any email addresses and if it found any (IF is KEY) it would then open Outlook and place all of the addresses in the TO:.

Finally, I don't want it to actually email. I want it to simply put all of the addresses into the TO field. I will then enter the subject and the body of the message and send it.

[mariocatch]

just comment the .Send paramater if you don't want it to automatically send.