This is a simple mailer that sends an email using the nodemailer package.
Node.js and npm are required to run this project. You can download them from the following links:
Clone the repository and navigate to the project directory in the terminal.
git clone https://github.com/ConducereIT/send-mailer/
cd send-mailerTo install the dependencies, run the following command in the terminal:
npm install To use the mailer, you need to configure the following environment variables:
SEND_MAIL_HOST: The host of the mail serverSEND_MAIL_USER: The username of the mail serverSEND_MAIL_PASS: The password of the mail serverSEND_MAIL_SERVICE: The service of the mail server
You can configure the environment variables by creating a .env file in the root directory of the project and adding
the following lines:
SEND_MAIL_HOST=smtp.gmail.com
SEND_MAIL_USER=...
SEND_MAIL_PASS=...
SEND_MAIL_SERVICE=GmailYou need to have a .xlsx file with a column for the email addresses. You can configure the file path by changing
the excelName variable in the backend.ts file.
example to run the mailer:
await sendMailviaXlsx("data.xlsx", "ETTI", "Mail", "Test", "Text");where:
data.xlsxis the file pathETTIis the sheet nameMailis the column name for the email addressesTestis the subjectTextis the message
await sendMailviaXlsxHTML("data.xlsx", "ETTI", "Mail", "Test", "<body>a</body>");where:
data.xlsxis the file pathETTIis the sheet nameMailis the column name for the email addressesTestis the subject<body>a</body>is the html message
To use the mailer, run the following command in the terminal:
npx tsx backend.tsThis project is licensed under the MIT License - see the LICENSE file for details