autoMailBot

Usage: There are four existed sheets, Subject, NameList, BodyList, and ErroList. In Subject:

1. The second cell in A column is the subject of the mail
2. The second cell in B column is the switch of sending mail automatically. (==1, auto send. ==0 display mail) In NameList:
3. The first cell of each column is the title. Input data are from the second row.
4. Names are stored in A column
5. their mail addresses are stored in B column
6. Tags are stored in C column
7. Send the mail automatically In Body:
8. The first cell of each column is the title. Input data are from the second row.
9. Tags are stored in A column
10. Body are stored in B column
11. SenderDate are stored in C column
12. If "END" appears in a cell of A column, it means the body list is end Body and Sender and Date in the mail Auto mail bot:
13. The mail context should be selected from "BodyList" by matching tags.
14. If there is no matching tag, please generate a new sheet, ErrorList, and copy the wrong row to the ErrorList. The first cell of each column is the title. Errors are stored from the second row.
15. The context of mail: Hello Name, body Best, SenderDate