Now it is just a matter of selecting the right merged field in the main document. All the available fields/columns names are ready for selection. Insert the cursor where you want to insert the merged fields.

No#4: Insert the Variable Data fields into the main document. This will now connect the main document with the excel recipients records file and ready to insert the fields into the respective blank spaces. From the Select Data source dialog box, look for the Excel file that contains the list of recipients and click OK. Now, you are ready to integrate the Excel file into the main document. No# 3: Integrate the Excel Student Records as recipients list. These are variable pieces of information that needs to be specific to each student while the rest of the information is general to every student. As shown below, is needed for the address, title and full name, program information and fees. In the main document, leave blank spaces in places where the personal information can be inserted. Prepare the main document, in this example the Offer letter. The records kept in Excel be easy to integrate into the offer letter.įor more information on mail merge using spreadsheet records, here is one good article form Microsoft office support site, Mail Merge Using An Excel Spreadsheet No# 2: Prepare the Main Document For example used here, the list of students accepted by the institutions with the program and fees details as shown below. It is important to create the list of recipients in Microsoft Excel 2016. No# 1: Create the list or record of recipients in Microsoft Excel 2016. It doesn’t have to because Microsoft Word 2016 already has commands under Mailings tab to do a much faster way. However, if the student numbers is more than 100, it’s a tedious repetitive task.

If the accepted students list is less than 20 is manageable by inserting the above piece of information for each student in. The rest of the information in the letter will be standard or same but the following information has to be personalized to each student. Certain piece of information on that letter musts be personalized to each student. For example, an offer letter issued to for students accepted to study in an institution. Microsoft Word 2016 has made it so simple to create just one document and then personally address it to different recipients so that each recipient will have personalized details of important information.

Office 2016 mail merge currency