如何使用Nodemailer SMTP从excel文件中通过电子邮件发送自定义消息给用户列表

npm install nodemailer

const nodemailer = require('nodemailer');

// 创建一个SMTP传输对象
const transporter = nodemailer.createTransport({
  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'
  }
});

const XlsxPopulate = require('xlsx-populate');

XlsxPopulate.fromFileAsync('path/to/your-excel-file.xlsx')
  .then(workbook => {
    const sheet = workbook.sheet(0); // 假设要读取第一个工作表
    const data = sheet.usedRange().value(); // 获取工作表的数据范围
    // 处理数据和发送邮件的逻辑代码
  });

data.forEach(row => {
  const email = row[0]; // 根据您的Excel文件的列顺序和数据格式，获取用户的电子邮件地址
  const message = `Dear ${row[1]},\n\nYour custom message goes here.`; // 替换为您的自定义消息内容

  const mailOptions = {
    from: 'your-email@example.com',
    to: email,
    subject: 'Your Subject',
    text: message
  };

  transporter.sendMail(mailOptions, (error, info) => {
    if (error) {
      console.log(`Error sending email to ${email}: ${error}`);
    } else {
      console.log(`Email sent to ${email}: ${info.response}`);
    }
  });
});