mailto option

F

fakechi

Hi...

I am new to this so I hope someone can help.

I have a list of ID's (020202, for example) in column A and text in
column B (@blah.blah.blah) together they make up an email address. I
was hoping to just CONCATENATE them into column C to have a link which
I could click, which in turn would fill in the To: box in an email
message. However, this does not work. If I type the email address
directly into the cell it works but as I have about 1000 of these ID's
I was hoping I didn't have to type each email address manually. Any
ideas?... Anyone?... Please?...
Your help is appreciated.

fakechi
 
R

Ron de Bruin

Try this

Select a cell in column C and run it(maybe you must change the sheet name)
You can make a loop for all the 1000 cells
If you need help post back

Sub test()
With ActiveSheet
.Hyperlinks.Add ActiveCell, ActiveCell.Value
End With
End Sub
 
D

Dave Peterson

How about this:
=HYPERLINK("mailto:"&A1&B1)

And if A1 is numbers and you have it formatted to show those leading zeros:
=HYPERLINK("mailto:"&TEXT(A1,"000000")&B1)
 
Top