Mailroom / Guides
Guides to sending personal email to a list from Gmail
Each guide answers one question and then gives the exact steps. All of them use your own Gmail account, a CSV file and nothing you have to install.
How to
- How to do a mail merge in Gmail from a CSV fileSend a personalised email to everyone in a CSV file from your own Gmail account. Step by step, with no Chrome extension and no Google Sheet.
- How to send bulk email from Gmail without a Chrome extensionSend personalised bulk email from your Gmail account using a web app instead of a browser extension or add-on. Nothing to install, works on any browser.
- How to do a Gmail mail merge without Google SheetsMost Gmail mail merge tools are Google Sheets add-ons. Here is how to mail merge from a plain CSV file instead, with no Sheet and no add-on.
- How to mail merge from Excel to GmailSend personalised emails from Gmail using a list in Excel. Save the sheet as CSV, upload it, and each row gets its own email. No Outlook or Word needed.
- How to send one email to many people individually in GmailSend the same email to a list so each person gets their own copy and nobody sees the other recipients. A better option than Bcc, from your own Gmail.
- How to personalise bulk emails in Gmail with merge tagsAdd each person's name, company or any other detail to a bulk email sent from Gmail, using merge tags that fill in from a spreadsheet.
- How to schedule a bulk email or mail merge in GmailWrite a personalised bulk email now and have Gmail send it later. Schedule a whole mail merge for a date and time, free.
Use cases
- Send personalised event invitations from GmailEmail invitations, reminders and joining details to a guest list from your own Gmail, each one addressed by name. Free for small events.
- Send a small newsletter from your own GmailFor a few hundred subscribers, send your newsletter from Gmail instead of an email marketing platform: personal, plain, and from an address people recognise.
- Email every parent or student individually from GmailSend each parent or student their own email with their name, class, grade or appointment time, from a school Gmail or Google Workspace account.
- Email your members from GmailFor clubs, societies and charities: send members personal updates from the group's own Gmail, without paying for an email platform.
- Send personal updates and reminders to your customers from GmailSmall businesses: email existing customers their renewal date, appointment, order status or a service update, individually, from your own Gmail.
Free tools
- Free CSV Email List CheckerFree tool: check a CSV contact list for invalid addresses, duplicates and blank rows before a mail merge. Runs in the browser; the file is never uploaded.
- Gmail Sending Limit CalculatorFree tool: how many days a list takes to send from Gmail (500/day personal, 2,000/day Workspace) and whether it fits Mailroom's free tier.