![mail merge from an excel spreadsheet mail merge from an excel spreadsheet](https://xlinexcel.com/wp-content/uploads/2019/04/Mail-merge-using-an-Excel-spreadsheet-xlinexcel.com-1.jpg)
You can relink your template and spreadsheet (or link your template to another spreadsheet) by clicking on Mailings and choosing "Select Recipients".When you update your Excel spreadsheet, the changes will be applied the next time you open your template.Your template and your Excel spreadsheet are linked so you need to keep both files safe.Get printing! If you are unsure about the process, or if you’re worried you might have made an error, try test printing the first page or two, just to double check that everything will print as you want it to. For example, if you are creating address labels, you can select “Address Block”, and then match up the fields that need to be on the label with the column in your spreadsheet that has this information.ĭouble check that everything is as it should be!
![mail merge from an excel spreadsheet mail merge from an excel spreadsheet](https://spreadsheeto.com/wp-content/uploads/2020/08/start-mail-merge.png)
This is where you set out what information should be taken from your spreadsheet and how it should be laid out. Select “Use an existing list”, then browse to find where your spreadsheet is saved. This is where you link in your Excel spreadsheet. For this you can either use a template that you have created yourself OR you can download (and save) one of our templates which are available on our website. If you don’t have a compatible code, then you need to “Start from existing document”.A4/A5), then select the relevant code from the list of product numbers. Select the correct option under “Label vendors” (e.g. If you have a compatible template code select “Change document layout”, then click “Label options”.The Wizard will then guide you through the necessary steps, which are as follows: For earlier versions of Word, click on the “Tools” menu, select “Letters and Mailings” and then click on “Mail Merge”.)
![mail merge from an excel spreadsheet mail merge from an excel spreadsheet](https://xlinexcel.com/wp-content/uploads/2019/04/Mail-merge-using-an-Excel-spreadsheet-xlinexcel.com-2.jpg)
(For Word 2007 and after, click on the “Mailings” tab at the top of the page, click on “Start Mail Merge”, then select “Step by Step Mail Merge Wizard” from the list.