E-Mail Addresses in Excel

L

lzardkng34

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
 
R

RC

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
 
B

Barb Reinhardt

You could also do this:

If the data is in cells A1:A5

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

lzardkng34

RC's Method worked Perfectly, TYVM

RC said:
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
Click to expand...
 
Top