mailto option

  • Thread starter Thread starter fakechi
  • Start date Start date
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
 
Hi Fakechi,

Concatenate the two numbers in A1, B1 (excel doesn't like @ symbols at
the beginning so insert an apostrophe at the beginning and it's
ignored).

You should now have the mail address.

In row D, insert the formula:

=HYPERLINK(C1)

It will become a hyperlink and you could now hide any columns that you
don't want to show.

Use the cursor keys to get to cell D1 and drag down.

Dan.
 
Back
Top