thank you for the tutorial Mailtrap. i however do have a question. the cc function doesnt seem to be working. i am assuming its a syntax issue. in your video, the TO location had the email address along with &cc= . how do you get rid of it and have the addresses go to the proper locations.? thanks
Hey, thanks for watching! Do you mean hyperlink in the HTML email body? Like at 09:03? Assume you want to create an email with a subject, body text, and a hyperlink. You can construct it as follows: =HYPERLINK("mailto:recipient@example.com?subject=Test Subject&body=Hello, please visit this link: www.example.com", "Send Email") If you want to include more complex body text with a hyperlink, you need to make sure the URL is correctly included in the body: =HYPERLINK("mailto:recipient@example.com?subject=Test Subject&body=Hello, please visit this link: www.example.com", "Send Email") If you still encounter issues, it might be due to how Excel handles certain characters in the URL. Use %0A for line breaks and %20 for spaces. Here’s an example with line breaks and a properly encoded URL: =HYPERLINK("mailto:recipient@example.com?subject=Test%20Subject&body=Hello,%0A%0Aplease%20visit%20this%20link:%20www.example.com", "Send Email") Hope this helps. Let us know!
thank you for the tutorial Mailtrap. i however do have a question. the cc function doesnt seem to be working. i am assuming its a syntax issue. in your video, the TO location had the email address along with &cc= . how do you get rid of it and have the addresses go to the proper locations.? thanks
Hey, thank you for your comment and for watching our videos! For more detailed information, please, check out our article: l.rw.rw/xdre5m6367
Thanks for the video, it is great ! With the hyperlink method, is there a way to put link in the body ? I try and get the #Value message.
Hey, thanks for watching! Do you mean hyperlink in the HTML email body?
Like at 09:03?
Assume you want to create an email with a subject, body text, and a hyperlink. You can construct it as follows:
=HYPERLINK("mailto:recipient@example.com?subject=Test Subject&body=Hello, please visit this link: www.example.com", "Send Email")
If you want to include more complex body text with a hyperlink, you need to make sure the URL is correctly included in the body:
=HYPERLINK("mailto:recipient@example.com?subject=Test Subject&body=Hello, please visit this link: www.example.com", "Send Email")
If you still encounter issues, it might be due to how Excel handles certain characters in the URL. Use %0A for line breaks and %20 for spaces. Here’s an example with line breaks and a properly encoded URL:
=HYPERLINK("mailto:recipient@example.com?subject=Test%20Subject&body=Hello,%0A%0Aplease%20visit%20this%20link:%20www.example.com", "Send Email")
Hope this helps. Let us know!