Column C combines 2 fields (Column A&B) that contain email addresses. When I select Column C as the main email recipients in Sendgrid app, it sends separate emails to each individual in column C. However, if I select column C to cc: my emails, it correctly sends a single email to all recipients.

I would like ONE email to be sent to all the people in column C in the “To” field in sendgrip.

Can anyone explain why this is happening and help me find a solution?

Thanks!