I am attempting to send emails to a distribution list based on a trigger column (column E). Each row that contains the word "Captured" should send an email to the address in column A. The email body for these outgoing emails should contain content in column D. Ideally I would like the Name (B) and Client (C) to dynamically appear in the Subject of the email.
The code below, fires to the correct recipients but sends the same message body (last one within the list to all email addresses).
I am in need of this for a large project so any help would be amazing!
![]()
Please Login or Register to view this content.
Bookmarks