Hyperlink and mailto error.
Hi I’m having issue with a hyperlink mailto formula: the below formula returns a value error the second I fill f2 / sc with a name. Then l2 / email uses an xlookup to input the email into the cell
=HYPERLINK("mailto:" & [@Email] &
"?subject=New Call Record-" & [@Client] &
"&body=" &
"Hi " & [@SC] & "," & "%0D%0A%0D%0A" &
"Date: " & TEXT([@Date],"dd/mm/yyyy") & "%0D%0A" &
"Time: " & TEXT([@Time],"hh:mm") & "%0D%0A" &
"Caller: " & [@Caller] & "%0D%0A" &
"Company: " & [@Company] & "%0D%0A" &
"Client: " & [@Client] & "%0D%0A" &
"Message Received Via: " & [@[Message Received]] & "%0D%0A" &
"Urgency: " & [@[Urgency of Response]] & "%0D%0A%0D%0A" &
"Details: " & [@Details] & "%0D%0A%0D%0A" &
"Thanks," & "%0D%0A%0D%0A" &
"Bob",
"Send Email")
Any help would be amazing
[link] [comments]
Want to read more?
Check out the full article on the original site