View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Email Hyperlink Multiple Recipients

How about a small workaround?

Say your data is in A1:A10
Put this in B1:
=a1
But this in B2:
=b1&";"&a2
and drag down to A10.

Now copy and paste the value in A10 to your To: field in your email program.

Not quite a hyperlink, but not too bad.

Kim wrote:

I have a column that contains an e-mail link in each cell. Is there a way to
hyperlink to one blank e-mail message containing all of the addresses in
column?


--

Dave Peterson