Now, you need to check if the mail merge has been completed or not. In the next step, you need to check Mail Merge messages from Outlook.In the Subject line field, add the subject.You will see the Merge to E-mail window and choose the E-mail option given in the To box.Choose the Finish & Merge menu and you will get a list of options.You can get the next members one by one with a button.You will see the data and name are changed.For this, click on the Preview Results menu to have a look at the preview.In the next step, you need to have a look at the Preview of the file and close the Mail Merge.Repeat this procedure for the Data variable as well.You will notice changes in the Name option.You will see a menu appears with column names from the selected Excel file.Choose Name and click on the Insert Merge Field option.Now you can link the variables with the Excel columns.Check the option in, First row if the data contains the column headers.Select the Excel file from File Explorer.Open the Select Reception menu and click on the Use an Existing List.For this, the word file will format the mail based on the data from the Excel file. In the next step, you need to link the mailing data with the email.Your file is saved in the selected location.Select a location to save the file from the File Manager.Save this file and click on the File tab of the Excel file.
In this file, different data is added such as Name and Date are needed to be added in the mail body.
For this, open Microsoft Word from the Start Menu. First, you need to make the content ready in Microsoft Word.How to Mail Merge from Excel to Outlookīelow are some steps to follow that let you execute mail merge. With this option, you can find data from a source file and add that data to the mail body. Let’s see how to mail merge from Excel to outlook.īefore that let’s understand what is Mail Merge.Ī process that lets you send personalized emails automatically to a huge number of people on the bases of the database is called Mail Merge. With a mail server of any kind, you can set up a mail merge. Though mail merge is a cost-effective option you need to make an expensive platform for mailing. Mostly, this feature is used when you need to send personalized emails such as new offers, billing deadlines, etc. Sending emails to a large number of people is now just a click away. When you need to send bulk mail, mail merge from Excel to Outlook is a wonderful option to avail. Usually, people send mail through Google Mailbox or other mailing platforms. Did you ever hear about the Mail Merge feature used in Excel?