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

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

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


"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

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

RC's Method worked Perfectly, TYVM

"RC" wrote:

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


"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