passing data to email using hyperlink

[fqb34r]

Hi

i have been playing with opening an e-mail using a hyperlink and incertingdata but have got stuck this is were i am at

=HYPERLINK("mailto:someone@blueyonder.co.uk?SUBJECT=referal for " & C1 & C2,"send")

two things i need to do

1 i want a space between the first and second name in the subject bare (c1 & c2)

2 i want to put text in the body of the email i can do it with out c1 and c2 but not with

can anyone help

kevin

 

[daverunt]

Hi,

I found an example and it works if I enter data in the relevant cells
but I can't seem to get the syntax right using your data.

Apparently for any field after ?Subject you use & instead of ?
Post back if you figure it out!

=HYPERLINK(CONCATENATE("mailto:",A1,"?subject=",B1,"&body=",C1),"Send ")

 

[daverunt]

Ok think I cracked it: Body of the mail I put in C3

=HYPERLINK(CONCATENATE("mailto:someone@blueyonder.co.uk?SUBJECT=referal for "&C1 & " " & C2,"&BODY=",C3), "send")

 

[fqb34r]

thanks had to make some small changes but turns out to be better and got it all working

kevin