Shulou(Shulou.com)06/01 Report--

There is a customer who is engaged in foreign trade business and often needs to send mass e-mails, asking for dynamic contents such as the name of the product and the name of the recipient in the email.

He couldn't find a suitable free mass messaging tool, so I recommended him to use kettle and drew a process for him to send mass emails. (this friend is not an IT person, can't develop, but can only use Microsoft Office.)

(reprint please indicate: http://pdi.itpub.net)

In my mass email process, I also used a plug-in I previously developed (that is, adding the contents of the file as a field to the data stream). I have released the email process, plug-ins and kettle together. You can download the version of kettle here (this version is based on kettle 3.2 stable, modifies some common bug in kettle 3.2 stable, and integrates the plug-ins mentioned above, as well as several other commonly used plug-ins, such as pdf file read plug-in, table incremental input plug-in, etc., and integrates the runtime environment jre1.6).

[@ more@]

After downloading the software, it can be run without installation and direct decompression.

How to send a group email:

1. Extract the downloaded file to any directory.

two。

3. Edit the samples/transformations/mail/EMAIL_SERVER.xls file, enter the SMTP mail server you are using, and the user name and password of your mailbox, and set the email title, sender's name, and reply address here.

4. Edit the samples/transformations/mail/COMMENT.txt file and enter the contents of the message you want to send in groups. The content of the file can be in HTML format or plain text format, in the case of HTML format. The content of the message is dynamic, and the dynamic part is implemented using variables. The variable comes from the field in the EMAIL_ADDRESS file, and the variable format is ${field name}. For example, ${TITLE} represents the TITLE column in EMAIL_ADDRESS.xls, that is, replacing the ${TITLE} flag in the text with the value of TITLE column in EMAIL_ADDRESS.xls.

5. Double-click the SendMail.bat file in the root directory to develop group mail, and the log of the sending process (that is, the running log of kettle) is recorded in the samples/transformations/mail/sendmail.log file.

6. You can also set the SendMail.bat file as a scheduled task for windows, so that you can automatically schedule group emails.

(reprint Please indicate that it is transferred from http://pdi.itpub.net)

Flow chart of mass email:

If you want to learn more about the process of sending mass mail, you can double-click spoon.bat, open the graphical interface, and import the send_mail.ktr file located in the samples/transformations/mail directory.

You can also modify the process to support one or more attachments, embed pictures in the email content, and so on.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.