![quick spreadsheet mail merge quick spreadsheet mail merge](https://www.mtnevan.com/wp-content/uploads/2016/03/gmail-mail-merge-address-confirm-455x300.png)
![quick spreadsheet mail merge quick spreadsheet mail merge](https://i2.wp.com/yagisanatode.com/wp-content/uploads/2020/06/Document-Merge-using-Google-Apps-Script.jpg)
Recipient Excel spreadsheet is, select it and then in the Select Table dialogue box select the worksheet that contains yourĮnsure that the First row of data contains column headings is selected only where appropriate and click OK. Ensure that Use an existing list is selected and click browse. This is where our Excel spreadsheet ofĪddress details comes in. Use the current document selected and then click Next: Select recipients. Because we are going to write the letter after the recipients have been selected, leave In the panel on the right, ensure that Letters is selected and click Next: Starting document. In Word start the Word mail merge wizard by clicking Mailings > Start Mail Merge > Start Mail Merge > Step by Step Mail Merge Wizard. In Excel don't have any missing rows - the data should have a continuous range. To help the Word mail merge wizard identify the data correctly, it's best to ensure that the address details Address details of all those people who will receive the letter.So, to do a mail merge in Word you will need two things: The address details, but in this example, we will look at using Excel to hold this information. An Access database can also be used to hold On multiple copies according to recipients' name and address details held in an Excel spreadsheet. The mail merge function in Microsoft Word enables you to create a standard letter in Word and then change personal details