Help please! I need to send an email to a list of recipients based on a query. The intended recipients can change over time. Therefore, I have created a list within the system so that emails can be added or removed at any time by users that have access to the list.
I want to be able to query this list and send an email to the values returned. However, I am having an issue with using MessageBlock to do this.
It appears that to add recipients, they need to be added like this
AddRecipient("[email protected]","email1","TO");
AddRecipient("email2@gmail.com","email2","TO");
AddRecipient("[email protected]","email3","TO");
Therefore, I am not sure how to convert my query values to accomodate this.
I was hoping to be able to send one email with all the recipients included.
Or will I need to loop through a dataset and send a separate email to each recipient?
Any assistance would be greatly appreciated.
Thank you!!