The best way to store contacts is the use of an Excel spreadsheet as a huge number of contacts can easily be stored, sorted, bifurcated or merged. Excel spreadsheets allow us to do a lot of quick tweaks with the contacts and arrange, add or delete them according to our interest.

1. How To Mail Merge In Outlook
2. Outlook Mail Merge Excel List Outlook 2016
3. Mail Merge Excel To Outlook 2013
4. Mail Merge Excel To Outlook
5. Mail Merge Excel To Outlook
6. Mail Merge Excel To Outlook 2016

Now it’s time to send out the emails. While there is no built-in way in Outlook to do this, you can easily do this if you are using the Standss Outlook add-in Email Merge Pro for Outlook. Click the Email Merge Wizard button. The Wizard will guide you to creating your email and to choosing the Excel file as your data source. Basically, through the familiar Outlook interface, you can import a large mailing list (from Outlook Contacts, Excel or CSV files, MS-Exchange distribution lists or other sources) and Easy Mail Merge for Outlook will generate separate outgoing emails for each email address.

How To Mail Merge In Outlook

Here in this article, you’ll explore how to import email addresses from excel to the outlook distribution list. You can always import CSV contacts to outlook and it is a pretty handy task. let’s explore the trick quickly.

Get Your Contacts in Convertible Format

First and foremost, we need to get all the contacts in a convertible format. You just can’t import any Excel file into Microsoft Outlook. It should be in a specified file format.

Step 1. Open the excel workbook with the contact details that you wish to import.

Step 2. Arrange the information properly. For an example, ensure all the emails addresses are in the proper format. All the names are in a standard format and the phone numbers are in numerical format with area codes.

Step 3. Since Outlook only accepts Comma Separated Values (CSV) file format, we need to convert that spreadsheet in the desired format.

Step 4. Click on the ‘File’ menu and then click on ‘Save As’.

Step 5. Choose the destination folder location and under ‘Save as Type’ box, choose ‘CSV (Comma delimited) (*.csv)’ format and click on the ‘Save’ button.

Step 6. Microsoft Excel will give you some notifications while saving the CSV file format however that can be ignored. You can click on ‘Okay’ and ‘Don’t show again’ to move ahead.

Also Read: How to lock Cells In Excel To protect Data

Import Contacts from Excel

Now that we have our file ready, it’s time to import contacts from Excel to Outlook.

Step 1. Open Microsoft Outlook and go to the ‘File’ menu.

Step 2. Click on the ‘Open & Export’ option and select ‘Import/Export’ from the options.

Step 3. A new window will open with ‘Import and Export Wizard’.

Step 4. Select ‘Import from another program or file’ option from the available list in the wizard.

Outlook Mail Merge Excel List Outlook 2016

Step 5. Click on ‘Comma Separated Values’ and go ‘Next’.

Mail Merge Excel To Outlook 2013

Step 6. On the next screen, browse for the CSV file location from the destination you saved it.

Step 7. Under the options, you can keep ‘Allow Duplicates to be Created’.

Step 8. Click on the ‘Next’ button and it will ask for the destination folder where you wish to save you contacts.

Step 9. By default, Contacts should be selected. If it is not the case, scroll up or down and select ‘Contacts’ from the destination list. Click on the ‘Next’ button.

Step 10. Ensure that you have the checkbox checked on the next screen before you click on the ‘Finish’ button.

Step 11. Map the contacts in the required format. It is essential to have a standard format and get everything the right way. Click on the ‘Map Custom Fields’ on the top right of the box.

Step 12. It will open another window with parallel boxes to match ‘From’ and ‘To’ fields.

Step 13. Drag and drop the values from the left-hand side box to the right-hand side box on the destination field. For an Example, drag ‘Name’ from left to the ‘Name’ in the right box. Drag ‘Email’ field from the left to the ‘Email’ field in the right section. It will show the assigned values in the rightmost section of the box.

Step 14. Click on Okay and Finish buttons. It will take some time to process the request and sync done. You can go to the people section on the Navigation panel and see all your contacts imported in the Contact list of Microsoft Outlook.

Mail Merge Excel To Outlook

Import Email Addresses from Excel to Outlook Distribution List

Once you have all the contacts imported from an Excel spreadsheet to your Outlook contacts, you can easily follow this link to add contacts in an Outlook Contact Group. You can directly Copy & Paste contacts straight from Excel worksheet to Microsoft Outlook if you just need them for one-time use.

Summing Up

This article is a perfect guide to import contacts to Outlook from Excel sheets. We all know the easy ways to convert an Excel workbook into a CSV format that can easily be imported into Microsoft Outlook. Now is the time to get all your contacts at one place, by importing CSV contacts to Outlook and sync them across all your devices.

Read Next:

Sending email from a mail merge

So, I was recruiting research participants for a study and realized that I wanted to send them reminder messages to tell them to come to the lab for the days/times they signed up. However, I didn't want to write a bunch of emails by hand. I went back to my old friends - Word and Excel to do an email mail merge. I wanted the messages to go out on the day of the scheduled appointment - at something like 6:00 AM, but I'm usually sleeping then - so I thought Outlook could help me with that. Uh... well... kinda.

Here are the steps for the email merge

• Create an Excel spreadsheet with the names, email addresses and other information (mine had the date and time for the appointment
• Do a mail merge with Word, setting up all of the fields EXCEPT for the email address
• Execute the merge - Word will ask you for the email address's field

Mail Merge Excel To Outlook

So, I was able to get Word and Excel to fire off an email to my list of people, but couldn't get it to delay the sending of the email. My work-aroud? I set up an outgoing email rule to delay the sending of the email. The rub is that it would only delay the email by a number of minutes, as long as that number of minutes was less than 120.

Mail Merge Excel To Outlook 2016

Here are the steps for the mail rule to delay 120 minutes