Please help
35 minutes ago, AIO said:Hi there!
I am a student and have a school project with programming, and there is a little thing that is really bothering me, and have no idea how to solve. I have made a forum (using google) which collects reusults and based on said results sends a special email. To do this I used the script editor of excel, which seems to be a rip off of html and java. My problem is rather simple, the opening '{' does want to close with the ending '}'. I have checked, and have no open '{}'. It is willing to close till this paragrpah:
message = message + "<br/><br/> Regards <br/><br/> Automessagemaker"
var subject = "Survey results ";
var advancedArgs = {htmlBody:message};
MailApp.sendEmail(emailAddress, subject, message, advancedArgs);
After which I am unable to close the bracket. Any help?
Thanks in advance
First of all, please fix the formatting text color and back color to support the forum properly, also read this: https://linustechtips.com/main/announcement/12-please-use-code-tags/ This will explain how using code tags work. It is a lot easier to see your code if you use it since it will format better.
Anyway, to your problem. Since I do not have the entire code nor the error message you're getting I don't know if I'm even solving the issue you have. But what I can see is that the first line of code you provided:
message = message + "<br/><br/> Regards <br/><br/> Automessagemaker"
seems to be missing a semi colon. So try adding one after Automessagemaker" and it should be fine, probably (again, I cannot see the rest of the code nor the error message.
So use this instead:
message = message + "<br/><br/> Regards <br/><br/> Automessagemaker"; //Semi colon added to tell compiler that the code finsihed there and something new is comming.
Hopefully I understood and this helps you. Otherwise I will probably need more code and the error message you're getting to be able to help.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now