1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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

submitted by /u/Auzzieboi
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI formula generation techniques
#real-time data collaboration
#financial modeling with spreadsheets
#real-time collaboration
#formula generator
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#HYPERLINK
#mailto
#value error
#formula
#xlookup
#email
#subject
#body
#Date
#Time
#Caller