Old messages are being sent

[Alexiabr58]

Hi, I have the new FormEmailer installed on different spreadsheets, some of them sent emails with data coming form Importranges and some from Google Form responses.

There are 2 particular files I'm having issues with, one of them gets fed with form responses and the other with importranges.

Column A on both files gets marked with 'Email sent' once the script has sent the message over; however, a few days later, an email that had been marked with 'Email sent' gets emailed once more. I even added a field on the email where they get labeled as 'Duplicate' so the recipient safely ignores them.

This happens with both sheets, and doesn't happen with the others so I'm unsure what might be causing the problem. I made sure to check the triggers and even uninstalled and reinstalled the script multiple times. I also asked one of my coworkers to install it (thinking that the issue might be triggered due to quota or smth) but nothing has solved it so far.

I was looking for any suggestions, troubleshooting steps or tips I could follow to avoid these already sent items from being sent again.

Thanks (Love the emailer btw <3 )

[clyall]

Hi Alexia,

Are you able to share your spreadsheet(s) with me? Also, have you made any changes to any of the Google Script files?

[Alexiabr58]

Hi, I need to ask for permission to share the file since it doesn't have personal data. About the changes, there's another script file on that project that adds a formula to a cell on form submit. I can try removing it, for testing purposes or add it to a separate project on the same sheet; however, I have another sheet with the exact same setup that doesn't have any issues.

I'll let you know if the issue gets resolved by removing that other script or if I get permission to share the file with you.

[Alexiabr58]

Hey, this is an unrelated question to the main topic but I was wondering, is there any way that the body of the email respects the blank line breaks between paragraphs?

e.g. Cell B2 (which will be the body of the email) contains the following message:

Thanks for submitting this request. I reviewed it and found the solution to the problem on the following articles:

1. test
2. test

Thanks.

When the email is sent, the message loses the blank lines and it goes like this:

Thanks for submitting this request. I reviewed it and found the solution to the problem on the following articles: 1. test 2. test Thanks

[clyall]

Hi Alexia,

If you check the "HTML" checkbox above body, you can use the
HTML tag to insert line breaks where you want them. Hope this helps!

[clyall]

Lol sorry, I just realized GitHub parsed my HTML tag

<br> is the tag you are looking for

[jac68]

This issue also happened to me with the old (Henrique) script.

I was not able to find out the cause, but I guessed the trigguer was a form resubmission.