You could also do this:

If the data is in cells A1:A5

=hyperlink("mailto:" & A1 & ";" & A2 & ";" & A3 & ";" & A4 & ";" & A5)

"Barb Reinhardt" wrote:

Just make sure your hyperlink looks something like this:



"lzardkng34" wrote:

Hello,
I have Office 2003 and in Excel i have 6 different email addresses in 6
different rows. If I click on 1 it opens my default email program and enters
the address in the To... area, if I click another it opens a new email window
and does the same. What im looking to do is insert (multiple) either selected
or all email addresses in the same email's To... area. Can anyone help me
with this issue? Thanks in advance for any and all help