Mailto: multiple recipients from Excel hyperlink, using list of email addresses.

[abssorb]

Hi, I have a need to create a mailto: link to multiple mail addresses. The mail addresses are all in one column.

This works:
=HYPERLINK(CONCATENATE("mailto:",E25,";",E26),"LIST")

Where email addresses are in E25 and E26. I can increase this code to cover all the entries with a ; between each, but there are 200 and I know Excel is cleverer than this.

The following clearly won't work, but it might highlight what I'm trying to do.
=HYPERLINK(CONCATENATE("mailto:",E25:E126),"LIST")

I am using Excel2003, and I am not able to make use of macros. Any help appreciated.

 

[abssorb]

Bump

 

[RoryA]

If you can't use macros, then you are out of luck (unless you can use third-party add-ins) since the CONCATENATE function (and the & operator) won't work with multi-cell ranges. You would have to build the string up in chunks and then assign that result to the hyperlink formula.