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!
![Excel VBA [Email Scripts] - Tutorial by Mailtrap](/img/logo.svg){kind=logo}
