Auto-email-sender NPM

Auto Email Sender

Auto Email Sender is a simple Node.js package that allows you to send emails using an SMTP server. It supports sending emails with customizable HTML content and data extracted from an Excel sheet. This package is ideal for bulk email sending where email content is dynamic and personalized for each recipient.

Features

Send emails using any SMTP server.
Supports HTML templates for email content with dynamic placeholders.
Extracts recipient information (e.g., email addresses, names, and other data) from an Excel sheet.
Easy-to-use API with minimal configuration required.

Installation

Install the package via npm:

npm install auto-email-sender

Usage

Here’s how you can use the auto-email-sender package in your Node.js project:

Step 1: Prepare Your Excel File

Ensure your Excel file contains the following columns:

Email (the recipient's email address)
Name (the recipient's name)
Other columns (optional data to be included in the email)

Example Excel structure:

Email	Name	Data1	Data2
user1@example.com	Aniket Subudhi	Info1	Info2
user2@example.com	Swagat	Info3	Info4

Step 2: Create an HTML Template

Create an HTML file for the email content. Use placeholders in the form of {{placeholder_name}} for dynamic content.

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Email Template</title>
    <style>
        body {
            font-family: Arial, sans-serif;
            background-color: #f4f4f4;
            color: #333;
            margin: 0;
            padding: 20px;
        }
        .container {
            background-color: #fff;
            padding: 20px;
            border-radius: 5px;
            box-shadow: 0 0 10px rgba(0,0,0,0.1);
        }
        .header {
            font-size: 24px;
            font-weight: bold;
        }
        .content {
            margin-top: 10px;
        }
    </style>
</head>
<body>
    <div class="container">
        <div class="header">Hello {{name}},</div>
        <div class="content">
            This is a dynamic email message.<br>
            Here is some additional data: {{other1}}, {{other2}}.
        </div>
    </div>
</body>
</html>

Step 3: Use the Package in Your Project

Here’s an example of how to use the package:

const AutoEmailSender = require('auto-email-sender');

// SMTP configuration
const smtpConfig = {
    host: 'smtp.example.com',
    port: 587,
    secure: false, // true for 465, false for other ports
    auth: {
        user: 'your-email@example.com',
        pass: 'your-email-password',
    },
};

// Initialize the AutoEmailSender with the Excel file, SMTP config, and column names
const emailSender = new AutoEmailSender('path/to/your/excel/file.xlsx', smtpConfig, 'Email', 'Name');

// Set the subject and path to the HTML template
const subject = 'Your Email Subject';
const templatePath = 'path/to/email_template.html';

// Send emails for all rows in the specified columns
emailSender.sendEmailsForColumn(subject, templatePath);

Step 4: Run Your Script

To send the emails, simply run your Node.js script:

node your_script.js

API Documentation

`AutoEmailSender(filePath, smtpConfig, emailColumnName, nameColumnName)`

filePath: Path to the Excel file containing recipient data.
smtpConfig: SMTP configuration object for nodemailer. Must include host, port, secure, and auth properties.
emailColumnName: The name of the column containing email addresses.
nameColumnName: The name of the column containing recipient names.

`sendEmailsForColumn(subject, templatePath)`

subject: Subject of the email.
templatePath: Path to the HTML template file.

Example SMTP Configuration

const smtpConfig = {
    host: 'smtp.example.com', // Replace with your SMTP server
    port: 587,
    secure: false, // true for 465, false for other ports
    auth: {
        user: 'your-email@example.com',
        pass: 'your-email-password',
    },
};