formula for mailto + cc

[keinz]

hi everyone,

trying to get this formula to work properly

at the moment i have this formula - that pretty much hyperlinks a cell to open up outlook to email to cell A2 and cc cell a3
=HYPERLINK("mailto:"&A2&"?cc="&A3, "NAME" )

Issue I am having is that I'd like to be able to display "NAME" as whatever info is in B1

 

[Roderick_E]

Huh? Am I missing something?

=HYPERLINK("mailto:"&A2&"?cc="&A3, B1 )

 

[keinz]

Huh? Am I missing something?

=HYPERLINK("mailto:"&A2&"?cc="&A3, B1 )

you didn't for some reason i was overthinking it..

now im having the issue of trying to CC in multiple people

current formula is:
=HYPERLINK("mailto:"&I50&"?CC="&Q50, P50)

so i tried
=HYPERLINK("mailto:"&I50&"?CC="&Q50,&T50, P50)

but its combining both emails together without a space so outlook isn't recognizing it

any inputs?

 

[daverunt]

You need to add the ';'

=HYPERLINK("mailto:"&B10&"?cc="&B12&";"&B17,B15)