Mailto

[craig]

Hi

I have a question that is driving me mad and hope someone
can help !

Excel 2000.

I have a list of employess (500)that I need to type their
email address (all the same company). Easy enough I add
their first name and Surname to different cells, then add
the @bladeblah.com, then put them all together in one cell.

What I am struggling to do is set the Mailto property
to "D4" or whatever cell I am trying to use, all that is
happening is when I have done the steps above it is
leaving the mailto to the first name I have entered. I
need it so when I copy my formula down to all the cells is
automatically bring in the mailto: for that name

For example

A B C
1 Craig Smith (e-mail address removed)
2 John Doe (e-mail address removed)

as I copy down the formula form row 1 it is putting the
correct name in (John Doe) but the Mailtoroperty is
still using Craig.Smith...

can anyone help ?
Thanks

 

[Ron de Bruin]

Try this

=HYPERLINK(A1&"."&B1 & "@blablah.com")

 

[Guest]

Thanks for the reply....but it doesn't work, it states it
can't open the specified file, (when you hover over the
top of the cell it is missing the mailto: bit)

Thanks again

-----Original Message-----
Try this

=HYPERLINK(A1&"."&B1 & "@blablah.com")

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




"craig" <[email protected]> wrote in

message news:[email protected]...

 

[Ron de Bruin]

Sorry I forgot to add it

=HYPERLINK("mailto:" & A1&"."&B1 & "@blablah.com")

 

[craig]

Hi

Thanks again !!! that has done it, but (!) it leaves
mailto in the field - is there a way to get rid of this ?

 

[Dave Peterson]

Look at the Help for =hyperlink(). You'll see you can add a friendly name as a
second argument.

=HYPERLINK("mailto:" & A1&"."&B1 & "@blablah.com", A1&"."&B1 & "@blablah.com")

 

[craig]

Thanks for your help on this

craig

-----Original Message-----
Look at the Help for =hyperlink(). You'll see you can add a friendly name as a
second argument.

=HYPERLINK("mailto:" & A1&"."&B1 & "@blablah.com", A1&"."&B1 & "@blablah.com")


--

Dave Peterson
(e-mail address removed)
.