Can I add data to the email from a column on the Responses Sheet that was not populated by the Form itself?

[Mike @ New Story]

I have populated one of the blank columns of the Form Responses Sheet with a list of unique promo codes that I would like to send to each respondent in the confirmation email itself. How do I get the confirmation email to print data from that pre-populated column? I have added a line to the Confirmation Email that says "Your unique Promoters Code is <strong>${"Promo Codes"}</strong><br>." However, when it sends the email, it doesn't seem to actually find that column - it's just blank where the promo code should be. Is it possible to get it to pull from that column to print the code?

Thanks

[hocdu...@gmail.com]

It does not support the sheet data curently. Let try Sheet Easy Mail Merge add-on for google sheet.

Best regards.