I have a spreadsheet that is supposed to send to a client list certain information.

I want the Email to be editable from the Spreadsheet to avoid the end users from having to look at the AppScript code at all.

So I have a cell that looks something like this:

To create an order please click here and follow the instructions. 

Then I build the email body by calling the different cells that have the relevant info like this:

 var messageBegin = ss.getRange('Correo!G1').getValues();
 var messageLink = linkText;
 var messageEnd = ss.getRange('Correo!G11').getValues();
 var message = messageBegin + messageLink + messageEnd;

Problem is the email ends up having the HTML code visible instead of a usable link, i.e. literally says: To create an order please click here and follow the instructions.

I'm fairly sure this is a stupid fix but I can't figure out how to make it work.

Thanks!