Q: Can AttachmentMailerTool read the recipient list from a database?

A: Yes, AttachmentMailerTool can directly read the recipient list from the database. Please follow these steps to modify the task configuration:

Step 1: In the Task Manager, locate the "AttachmentMailerTool" task. Right-click on it and select "Edit task config".

Step 2: Click on "Recipient List (Loop Data) Config".

Step 3: Choose the data source that contains the recipient list, enter your SQL query, and click "Test SQL".

Note: The query result must include the following columns:

To_Emails

CC_Emails

Subject

Body

File_Path

Admin_Password

Open_Password

Watermark_Text

Click here to view a detailed explanation of each column.

Step 4: Click "Deploy" to publish the updated task configuration.

After deployment, the task will retrieve the email list from the specified database table the next time it runs.

Note: Once configured this way, AttachmentMailerTool will no longer read the email list from Excel. To avoid affecting the original task, you can clone the AttachmentMailerTool task in Task Manager and apply these changes to the cloned task instead.

Modify the cloned task as needed and deploy it independently.