In this article:

Automate Emails from Excel (Easiest Way in 2024)

In this article, we explain how to send automatic reminder emails from an Excel spreadsheet. Simply follow the steps below!

Setting Up Automated Excel Email Reminders with Lido

Below we outline the steps on how you can automate reminder emails from your data in an Excel spreadsheet:

1. Add Excel Data to Lido

Before you can send reminders, you need to import your data into Lido. If you do not have a Lido account yet, sign up for free at: https://www.lido.app/go/signup

Lido functions like an enhanced spreadsheet that helps automate tasks by linking data directly to emails. To use Lido’s automated email sending functions, we need to import our data from Excel into our Lido spreadsheet.

There are two ways to do this:

1. Copy the data from Excel to Lido. In Excel, select the table range you want to copy, then right-click and hit “Copy”.

automate emails from excel

In a new spreadsheet in Lido, right-click an empty cell and click “Paste”.

automatic email from excel

2. Alternatively, you can use Lido’s “Upload spreadsheet” function. You can find this by navigating to FileUpload spreadsheetExcel file.

auto send email from excel

Once your data is formatted, right-click the selection and choose "Convert Table from Range". Save your named table and proceed to the next step.

automated emails from excel

2. Set Up Reminder Timing

With your data ready in Lido, decide when the reminders should be sent. Usually, reminder emails are sent ahead of a user’s deadline. For example, to send a reminder two days before a due date, use this formula:

`reminder_date = deadline_date - 2`

Where deadline_date is the cell containing the deadline date. If the deadline is stored in column C, then the deadline of the first listed entry will be in C2. The formula becomes

`=B2-2`

how to automate sending emails from excel

Hit enter to create a computed column. This is a special column type in Lido that will automatically apply the same formula to every row in the column. This is particularly useful if you add more records to your Google Sheet or to the bottom of your table, since the formula will be applied to the new rows automatically.

We can name this column Send Date.

sending automated emails from excel

3. Compose the Reminder Emails in Lido

Now, prepare the email content:

Create email templates

First we will create templates using our table column names as variables by referring to them with [@Column] syntax.

Set up templates for email subject and body in a new worksheet like this:

how to automate emails from excel

Create Email Subject and Body referencing the templates

Now we need to combine these templates with our table data in the other tab to make the email content dynamic. We'll do that by creating two new computed columns for both Subject and Body. We will use a formula called STRINGTEMPLATE() inside of a computed column to do this.

First, make a new computed column and name it Subject.

send automated emails from excel

Add this formula to row 2 in the Subject column:

```=STRINGTEMPLATE(Templates!$B$1)```

In our example, Templates!$B$1 is the location of our subject email template. Make sure you replace this with your own cell location if it is different, otherwise the formula will not work. Also, remember to anchor the cell reference with $, as all rows will use the same template cell.

You should now have a subject column that looks like this. Notice how the payment deadline is different for each row based on the values in column C.

automate sending emails from excel

Now do the same thing for the email body. Make another computed column. Then apply the formula below. Remember to change the cell references to match your sheet.

```=STRINGTEMPLATE(Templates!$B$2)```

You now will have something that looks like this: 

how to send automatic emails from excel

4. Automate Email Sending with SENDGMAIL()

Lido's spreadsheet has a special type of formula called Action formulas. These are formulas that can send data externally but need to be triggered to run. Action formulas don't calculate immediately when you type them (as normal spreadsheet formulas do). You need to explicitly run them manually or with an automation. One action formula is SENDGMAIL, which lets you send an email directly from your spreadsheet.

SENDGMAIL works as follows:

=SENDGMAIL(sender, recipient, subject, body, [status_cell], [cc], [bcc], [attachments])

Where:

sender - a credential you create for your@email.com (This should be associated with a Gmail or Google Apps account)

recipient - the email of the person that will receive the reminder

subject - the email subject

body - the email body

Our core SENDGMAIL formula looks like this:

=SENDGMAIL(<sender-credential>, C2, E2, F2)

Add logic for when you want the reminder email to be sent

If we want to have SENDGMAIL run only when today's date is the reminder send date, then we want to add an IF statement:

=IF(TODAY() = <reminder send date>, SENDGMAIL(<sender-credential>, recipient, subject, body))

The formula works as follows:

If today's date is equal to the send date, then display the SENDGMAIL formula, otherwise display FALSE.

Create a new Computed Column

Let's create a new computed column, and enter our formula below in row 2 (remember to adjust the formula for your data). We can double click on the header cell, and rename the column to Send Reminder.

```=IF(TODAY() = D2, SENDGMAIL(<sender-credential>, B2, E2, F2))```

how to send automated emails from excel

As you can see, the SENDGMAIL formula is only visible for dates when Send Date = Today. For all other days it displays FALSE.

Send a test email

Right click on the SENDGMAIL formula and click "Run Action'' to send the email. You will be asked to authenticate into your Gmail account the first time that you send an email from Lido.

can excel send automated emails

5. Schedule and Automate Reminder Emails

Finally, automate the sending process:

Now, we can automate the running of the Send Reminder column. For rows where SENDGMAIL displays in the column, Lido can automatically run them once per day, even if the file is closed.

Click on your Send Reminder column menu and select Run column on a schedule.

automatic emails from excel

Select what time of day you want your messages to send, then click save.

send automatic emails from excel

Now, every day at 1:15PM (or whatever time you've selected), Lido will pull in the latest records from your Googlle sheet, automatically check and see if there are any reminder emails that need to be sent where TODAY = <reminder send date>, and if so, run the each SENDGMAIL formula and send the emails.

Impressed? Click here to get started with Lido!

FAQs

Here are some frequently asked questions:

How to Automate Email Reminders a Week Before the Date?

Easy. In the Step 3 above, just change the number in the formula. For the example that we use, we have the following formula:

=B2-2

This will send the reminder two days before the deadline. To send the reminder a week before the deadline, just change the number to 7 (7 days):

=B2-7

If instead you want to send the reminder 3 days before the deadline, just change it to 3:

=B2-3

And so on.

How do you Check if your Formula Works First?

You can check if the formula works first before setting the automation settings. First, change the sender_email and recipient_email to the one you can open. Afterwards, click the cell containing the formula for sending reminder emails. Then, click right click on the SENDGMAIL formula and select Run action

Lido will run the formula. If the formula has no errors, the message Action run successfully will appear on the lower-right corner of Lido. 

How to Send Automated Reminder Emails Multiple Times for the Same Person?

You can also send reminders a few times at different times to the same person. You just need to repeat the Steps 3 to 6, adding a set of columns for each instance.

We hope that you now have a better understanding of how to automate email from Excel. If you enjoyed this article, you might also like our article on how to set up expiry date reminder in Excel.

Schedule a free automation consult
Learn more

Level up your Google Sheets skills with our free Google Sheets automation guide

Wasting too much time doing things manually in spreadsheets? Want to spend more time doing what you love? Our 100% free, 27-page Google Sheets automation guide is full of new tips and tricks that will save you time and money!