email hyperlink
 

i want to have a cell (named ALL EMAILS) linked to a long list of addresses.
when i use hyperlink function - e-mail addresses field will only let me input
certain amount of characters; my question is HOW do i either expend that
field OR is there any other way to make that work?