Recipients will change if you click on the arrow shown in box 12. Step 6: Here you can check by using the “ preview result” option. Click on “ insert merge field” → Select the unique data from the list which you want to change as per recipients Step 5: Insert merge field gets enabled after uploading the excel data source sheet. You have to select that particular sheet in which input data is present). Step 4: Select an Excel sheet where your data is stored and click on “ok” (once you click on open, a new window will pop-up and it will show all the sheet of that excel file. Step3: Select a data source where you have saved the excel file with all the customer details → Click on “open”. Step2: Write a common mail body which you want to send to all customer → click on select recipients → click on use an existing List Step1: Open Microsoft word → Go to mailing tab → click on start mail merge → click on E-email messages If the header is not there then it will be difficult for you to select the field. Hence, each column must contain header so that you can select from the list because in the “insert merge field” option you can only see column title or header. Note: Header row (title) must be there for each column, as in mail merge data is tracked according to the column title.
One sample format is shown in the below image. Prepare the data in an excel sheet (.xlsxįormat) which contain unique data and email address to whom you want to send anĮmail. Note: To send a mass email outlook should be installed on your laptop. Therefore, the mail merge allows you to send an email to all customers in just a few clicks. If you want to send the same email or letter to thousands of customers then it becomes a very tiresome activity to send emails to all customers one by one.
Mail merge is a very important feature of Microsoft word which helps to send mass emails, create letters, create envelopes and labels.
0 kommentar(er)
