Combining Hyperlinks

[MIchael Shef]

I'm using an excel sheet to keep track of list of parents & volunteer for a Cub Scout Pack.

I have them broken down into dens and each den has a hyperlink of all the email address in that specific group.

I'd like to create a hyperlink that collects all the individual den emails and combines them into one 'master' hyperlink.

When I try to cut and paste all the email addresses into one hyperlink it wouldn't allow that many addresses in one link.

Please advise.

Thanks

 

[lmvk99]

Followed the directions and when I hit F5 I get the following:

Run Time Error '1004'
Application-defined or object defined error

Do it again and when you get the error, hit debug and it will highlight the line of code that's wrong. Let me know what it is...