Mail merge is a feature within most data processing applications that enables users to send a similar letter or document to multiple recipients. It enables connecting a single form template with a data source that contains information about the recipient's name, address and other predefined and supporting data.
This template contains the following steps:
1) Read .txt file that contains letter or document.
2) Read Excel file that contains email and predefined information that the user want to replace in content.
3) Replace predefined value from actual value.
4) Send mail to recipients.
You can use this in any project as well as a standalone workflow.
NOTE: The predefined value in Content is the same as column name in Excel and before using this template, set your email credential, server detail and sender details also.