Skip to content

Send personalized emails from an Excel spreadsheet

Prepare your contact spreadsheet, match name and company columns, and use personal notes to create a separate email for each recipient.

Published
Updated
Length
5 min read
Send personalized emails from an Excel spreadsheet
Contents 9 sections
  1. Use one row per contact
  2. CSV or XLSX?
  3. What should you check when importing into uLemio?
    1. 1. Connect the email account you’ll send from
    2. 2. Select the file and check the columns
    3. 3. Review skipped rows
    4. 4. Choose the personal note column
    5. From sign-up to your first send
  4. How are message fields filled in?
  5. A short check before sending
  6. What if the list has more than 30 people?
  7. How can you follow up with people who do not reply?
  8. Common questions
    1. Does uploading the file send the emails?
    2. What happens if a contact has no name?
    3. Does an address check prove the address works?
    4. Can I use this without Excel?
  9. When your list is ready

Put each contact on a separate row in Excel, then upload the XLSX or CSV file to uLemio. Use the name, company or personal note columns in your message and preview how it will look for each person before you send.

Use one row per contact

Three columns are enough to start:

  • Name
  • Company
  • Email address

If you have written a different opening sentence for each person, add a “Personal note” column too.

NameCompanyEmail addressPersonal note
Gül YurtExample Chemicalsgul@example.comWe discussed your packaging requirements at the trade show.
Deniz AcarExample Textilesdeniz@example.comThis may suit your new product range.
Ali KayaExample Metalsali@example.comI have prepared the information you requested in our last conversation.

These names and addresses are illustrative. Do not use them as recipients. In your own list, use real addresses you are entitled to contact.

Putting several people’s addresses in one cell, leaving column headings empty or repeating the same person in several rows makes matching harder. Keep the contact, company and note in separate columns.

An example spreadsheet with Name, Company, Email address and Personal note columns. Each row contains one contact; addresses are illustrative.

CSV or XLSX?

uLemio accepts Excel (.xlsx) and CSV files up to 5 MB. CSV stores rows and columns as plain text.

  • If your Excel workbook is ready, upload it as XLSX.
  • If you exported the list from another tool, you can use CSV.
  • If accented characters appear incorrectly in a CSV, check its UTF-8 encoding.
  • For a short list, you can paste addresses instead of preparing a file.

Renaming a file “CSV” does not convert its contents. Use your spreadsheet program’s export or save function to create the correct format.

Example CSV:

Name,Company,Email address,Personal note
Gül Yurt,Example Chemicals,gul@example.com,We discussed your packaging requirements at the trade show.
Deniz Acar,Example Textiles,deniz@example.com,This may suit your new product range.

What should you check when importing into uLemio?

1. Connect the email account you’ll send from

Decide which account will send the emails. Uploading a list does not create a new sender address; you connect your own email account.

Use an eligible Gmail, Google Workspace, Yandex or supported business email account. Check which accounts uLemio supports before importing your list.

2. Select the file and check the columns

uLemio tries to match columns such as name, company and email address. If headings differ or an expected field is not recognized, review the mapping.

In the first-row preview, verify the email address, name and company. Correct any columns uLemio matched incorrectly.

3. Review skipped rows

You may see explanations for duplicate, invalid or ineligible addresses. Some rows may also be left out because of capacity limits.

Read the reason before uploading a skipped row again. If another send already has emails or follow-ups pending for the same person, the product may prevent starting another active series for that address.

4. Choose the personal note column

If you have prepared a different sentence for each person, match that column to the personal note field. uLemio does not research or write the sentence for you; it uses the information in your list.

From sign-up to your first send

  1. Create an account

    On ulemio.com/register, enter your name, email address and a password, and accept the terms of use. Open the verification link sent to your address and the account is ready. The first 100 accounts to join the pilot stay free. No credit card required.

    uLemio sign-up screen: name, email address and password fields with the “Create account” button.
  2. Connect your email account

    Choose “Find automatically” and enter your email address to see your connection options. For eligible Gmail or Google Workspace accounts, enter the app password you created in Google. uLemio also supports Yandex and eligible company-hosted mailboxes. Outlook.com, Hotmail and Microsoft 365 accounts are currently unsupported.

    Connecting an email account in uLemio: the “Find automatically” option plus Google, Yandex and SMTP/IMAP choices.
  3. Upload your list

    Choose a CSV or XLSX file up to 5 MB, or paste your email addresses. Verify the matched columns in the first-row preview and select “Import list”. If you wrote a sentence for each person, select the “Personal note column”.

    uLemio List step: customer-list.csv uploaded; Email, Name, Company and Personal note columns matched, with a first-row preview.
  4. Write your message

    Write the subject and the first email. The {ad}, {firma} and {kişisel} fields are filled in from your list for each person (name, company and personal note); the preview shows what the recipient will see. You can add up to two follow-ups for people who do not reply.

    uLemio Messages step: the email written with {ad}, {firma} and {kişisel} fields on the left, the filled-in preview for one contact on the right.
  5. Pick days and hours

    Choose when emails can go out. The default window is weekdays from 09:00 to 18:00. Your initial emails and follow-ups are spread across the times you choose and share a daily limit of 30 messages per connected account.

    uLemio Schedule step: Monday to Friday, 09:00–18:00, Istanbul time; dates for the first email and the first follow-up.
  6. Review and start

    Use “Send myself a test” to check the message in your inbox. Select “Start sending” when you’re ready. You can pause the send at any time. When uLemio detects a reply, it stops that person’s remaining follow-ups.

    uLemio Review and start step: summary of email account, list, messages and schedule; “Start sending” and “Send myself a test” buttons; the recipient’s email on the right.

Create a free account How does uLemio work?

How are message fields filled in?

uLemio uses three template fields. Their names stay the same in both interface languages; type them exactly as shown:

  • {ad}: the contact’s name.
  • {firma}: their company.
  • {kişisel}: the note you prepared for that person.

For example, your template could be:

Hi {ad},

{kişisel}

I would like to share suitable options for {firma}. Could you send the dimensions and approximate quantity you need?

The preview for Gül becomes:

Hi Gül,

We discussed your packaging requirements at the trade show.

I would like to share suitable options for Example Chemicals. Could you send the dimensions and approximate quantity you need?

Switch to another contact in the preview to check that fields are filled from the correct row. Include a row with a missing name or company; looking only at the most complete record can hide problems.

A spreadsheet row for Gül Yurt becomes an email with the name, personal note and company fields filled in.

A short check before sending

  1. Are these the people you actually intend to contact?
  2. Is the email column correct?
  3. Are any addresses repeated?
  4. Do greetings and personal notes belong to the right people?
  5. Is the subject and requested next step clear?
  6. Are the sending days and hours appropriate?

You can send yourself a test email. A test does not start delivery to your contact list. You start the send separately when ready.

What if the list has more than 30 people?

uLemio sends up to 30 emails per email account per day. Initial emails and follow-ups share that limit. Each selected sending account can take up to 30 contacts in a new send. Contacts already waiting for emails or follow-ups reduce the available space. Check the list limit shown in uLemio before you import.

Duplicating a send does not increase the daily allowance. Moving skipped contacts to another draft does not change that day’s sending limit. Check the capacity shown in the product.

The uLemio page explains the limits and the scope of free access.

How can you follow up with people who do not reply?

Send only the first email, or add optional follow-ups. A follow-up can use the same person’s name, company and personal note.

Instead of repeating a template without checking it, briefly refer to the previous email and ask one question. See follow-up email examples for different situations.

Common questions

Does uploading the file send the emails?

No. After adding the list, you complete the message, schedule and preview steps. Emails to your contacts begin after you start the send.

What happens if a contact has no name?

Check the greeting in the preview. Keep your message simple so an empty field does not make the whole sentence awkward.

Does an address check prove the address works?

No. A format or domain check is different from actual delivery. A recipient’s server can reject a message for other reasons involving the sender or content.

Can I use this without Excel?

Yes. Prepare a suitable CSV/XLSX file or paste addresses.

When your list is ready

Try a few rows first. Open uLemio to connect your email account, upload the file and preview the first message.

  • uLemio
  • Excel
  • Bulk Email

Author

Tufan Erdoğan

Channel Development Manager and Team Lead at Jotform. On this blog I share what I learn and experience.

The author of this guide also develops uLemio; read the parts that mention the product with that in mind.

About me