i built a google sheet for my team result. I need to send out "KPI report" in PDF for each staff. The name is stored on (B2), and I have set a Vlookup to linkup the staff email (D2) for mail merge. Somehow it doesnt work. It bounds back with below error msg.

Error
Exception: Failed to send email: no recipient (anonymous) @ Trial.gs:37 myFunction @ Trial.gs:12

Can anyone advise solution?

I believe you might need to add a variable here that ties to your sheet ID.