How to Create Mailing List and Send E-mails in Excel 365?
Tags: createamailinglistan, kutools
Published: 2020-08-07 14:52:53

---
title: How to Create Mailing List and Send E-mails in Excel 365?
published: true
date: 2020-08-07 09:04:10 UTC
tags: Createamailinglistan,Kutools
canonical_url: https://geekexcel.com/how-to-create-mailing-list-and-send-e-mails-in-excel-365/
---

## Create a Mailing List and Send E-mails in Excel:

In this article, we are going to see how to **Create a Mailing List and Send E-mails in Excel** 365 using **Kutools**. Here we will use a special function of kutools that is **Create Mailing List** and **Send E-mails**. Let’s get into this article and explore the ways to solve this task quickly.

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 120 features. You have to install it before using it.

## How to Create a Mailing List in Excel?

Here we come up with the steps to Create a Mailing List in Excel with the help of Kutools, do as follows.

- To create a mailing list, you have to **click** the **Kutools**  **Plus** tab, then **select** the **Create Mailing List** option under the **Mailings** section.

![Create Mailing List Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-10.png)<figcaption id="caption-attachment-11411">Create Mailing List Option</figcaption>

- It will open the **Create Mailing List Dialog Box.**
- You need to **Check** the **fields** which you want to add as columns in your mailing list in the Excel spreadsheet.
- You have to **specify** the number of **Attachments** that you want to add in your mail list.
- Then, **choose the location** to place the mailing list. You can select the **New Worksheet** or **Existing**  **Worksheet** option from **Choose where you want the mailing list to be placed** section.

![Create Mailing List Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-8.png)<figcaption id="caption-attachment-11413">Create Mailing List Dialog Box</figcaption>

- Now, you need to **click** the **Create** option in the above dialog box, your mailing list will be added with labels in the selected spreadsheet.
- Refer to the below example image.

![Mailing List with added specified columns](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-8.png)<figcaption id="caption-attachment-11415">Mailing List with added specified columns</figcaption>

- After that, you have to add the more recipient’s information (Email, First Name, Phone, Company, Attachment (1), Attachment(2)) as you need.

![Created mail list](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4-8.png)<figcaption id="caption-attachment-11417">Created mail list</figcaption>

Now, you are ready to send E-mails to multiple persons at the same time.

## How to Send E-mails from Excel?

Here we come up with the **Send Emails** option of Kutools to make you work simple.

- You have to **Select** the **Mailing List table** , and on the **Kutools**  **plus** Tab, Choose the **Send**  **Emails** option.

![Send Emails Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/5-8.png)<figcaption id="caption-attachment-11418">Send Emails Option</figcaption>

- Now, the **Send Emails dialog box** will be opened. You have to specify the needed information like attachment, recipients, subjects from each drop-down list.

![Send Emails Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/6-8.png)<figcaption id="caption-attachment-11420">Send Emails Dialog Box</figcaption>

- Then, you need to **choose** the **field** which you want to insert into the message body from the **drop-down list** and **click** the **Insert Placeholder** option.
- It will insert the selected field into the message body.

![Choose any field from the drop-down list](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/7-4.png)<figcaption id="caption-attachment-11421">Choose any field from the drop-down list</figcaption>

- You have to enter the message body in the text box available in the Send Emails dialog box.

![Enter and format message body](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/8-3.png)<figcaption id="caption-attachment-11424">Enter and format message body</figcaption>

- You need to specify the E-mail sending mode, By default **Send emails via Outlook** option is selected.
- In this article, we are going to send emails through the **Outgoing server settings** option.
- You can also select other E-mails sending mode by **unselecting Send emails via Outlook** option.
- Now, it will display the **Outgoing server (SMTP) settings- New scheme** dialog box, where you need to **check** the “ **Save sent emails to”** option to save the mail after sending.
- **Specify** the **sending interval** to send emails based on the list.
- Hit the **OK** button, a dialog box will pop out to get inputs for name and note for the new scheme. **Click** the **OK** button to proceed.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/12-1.png)

- If it shows any error, you have to go to this link [https://myaccount.google.com/security](https://myaccount.google.com/security)
- Make sure you have turned on **Access to less secure apps** then, bulk emails were sent.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/13-1.png)

- Now, you need to **click** the **Send** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/10-1.png)

- Kutools for Excel dialog box will be popped to tell you how many emails have been sent.
- Simply, click the **OK** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/16-1.png)

### Note:

- If you want to save the current message body as an HTML file, **click** the **Save to file** option in the Send Emails dialog box.
- Then, import it by clicking the **Load**  **from File** option.

![Choose Save to file Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/14-1.png)<figcaption id="caption-attachment-11443">Choose Save to file Option</figcaption>

![Choose Load from File](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/15-1.png)<figcaption id="caption-attachment-11444">Choose Load from File</figcaption>

## Configure E-mail Server Settings:

You can send emails in two ways.

1. **Send Emails Using Office365 Server**
  - SMTP Host – In this field, you have to give **smtp.office365.com**
  - SMTP Port – You need to give **25** as port number.
  - SSL Protocol – **Check(ON)** the SSL protocol.
  - SMTP Username – You have to give your **office365**  **username**.
  - SMTP Password – In this field, you need to give your **office365**  **password**.
2. **Send Emails Using Gmail Server**
  - SMTP Host – In this field, you have to give **smtp.gmail.com**
  - SMTP Port – You need to give **465** as port number.
  - SSL Protocol – **Check(ON)** the SSL protocol.
  - SMTP Username – You have to give your **Gmail**  **username**.
  - SMTP Password – In this field, you need to give your **Gmail**  **password**.

## Closure:

In this article, you can understand how to **create a mailing list and send bulk Emails in Excel 365** using **Kutools**. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [How to Filter Cells By Font Color in Excel 365? – Using Kutools](https://geekexcel.com/how-to-filter-cells-by-font-color-in-excel-365-using-kutools/)
- [Format Cells or Rows When Cell Value Change in Excel 365?](https://geekexcel.com/how-to-format-cells-or-rows-when-cell-value-change-in-excel-365/)