E-Mail Addresses in Excel

[Guest]

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

 

[Guest]

Just make sure your hyperlink looks something like this:

mailto:[email protected];[email protected]

 

[Guest]

You can click on the starting cell and hold down to highlight all the
addresses you want to email. Then copy and paste to the outlook "To" box.
The addresses will past goofy, but just tab or move yoru cursor to one of the
other buttons and the addresses will format correctly in your address bar.

Hope it helps.

RC

 

[Guest]

You could also do this:

If the data is in cells A1:A5

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

 

[Guest]

RC's Method worked Perfectly, TYVM

You can click on the starting cell and hold down to highlight all the
addresses you want to email. Then copy and paste to the outlook "To" box.
The addresses will past goofy, but just tab or move yoru cursor to one of the
other buttons and the addresses will format correctly in your address bar.

Hope it helps.

RC