Formula in Excel to display email message with CC & email receiver

[David77]

Hello everybody,

I am currently following this youtube video:

(specifically look at around 07:30-08:30) in order to create an email link in my excel file that people can click on, have a pre-determined email message written and then fill out the blanks and send it out.

However, while I tried following it, for some reason the code does not work for me. Could any of you perhaps try and see if you can get it to work?

This is what I have made so far with C5 being the button where I click to display and send the email:



However my code in C5 does not work for some reason (even though I basically replicated it directly from the youtube clip you sent me):



I think the code in my "Body" for the email is causing me a lot of trouble, which is written like this (with the %0A to create a space inbetween the text in the email format. By the way, I would like to create more than one space for the body for many of these messages. Would I just simply have to write %0B then? or something else?)



I hope this isn't too much to ask for - I would truly appreciate it! I am very much in the dark right now

Thank you very much for your time

Kind regards,
David