I need to take part of the subject from a sheet pivot. I have tried the below way. The script is fetching the value, but it's skipping one raw in the loop.
The appscript should have respective supplier name in the the subject, as per its there in the emailbody. but its skipping onenter image description heree iteration in the loop.
