I am new to Task Centre and just created a task which contains a query that results in 2 records with names and email addresses I then link this with an SMTP tool to send a test email to them. I have {=Steps("Database Query (ODBC)").RecordSet("EMAIL")} inserted into the To field on SMTP->Main screen. When the task runs only one email was sent to the first record. Could someone please advise what is missing here. Many thanks.
Tick Use RecordSource
Hi,
On the SMTP tool, on the first TAB, you need to Tick the use DataSource box and select the data source.
After choosing this, you should have all the fields from your ODBC under the SMTP tool
Remove what ever you inserted from the TO field, and add from the fields that are inside the SMTP tool.
That should fix your issue.
Nazer Mohamed