Click the Update Labels button to repeat the address field on all the labels of your document. The Address Block field is inserted onto the first labels on the document. Click the Match Fields button, ensure all fields are matched appropriately and click Ok This means Word 2007 has not recognised the heading used in your spreadsheet. If there is a problem with the display of one of the address fields, it is probably unmatched. From here you can select a format for the recipient’s name on the left and see a preview of how your labels currently look on the right The Insert Address Block dialogue box appears. This way takes a little longer but provides you with greater flexibility over presentation. Insert Merge Fields – Displays all the Mail Merge fields from the spreadsheet. This is quick and easy and makes the process almost effortless. You could use the Address Block field or individual Merge Fields.Īddress Block – Includes all required address related Mail Merge fields such as Title, First name, Last name, Address1, City and so on. To put address onto a label you have 2 choices. The fields should be laid out as if you were typing the data onto the label so don’t forget the use of spaces and carriage returns. Mail Merge Fields need to be inserted onto the labels to represent the data we would like displayed such as names and addresses. 
Select the required sheet and click OK Insert the Merge Fields
The Select Table dialogue box appears asking what worksheet of the Excel workbook holds the data you want to use.Navigate to the Excel spreadsheet where the recipient data is stored and click Open The Select Data Source dialogue box appears.Click Select Recipients and choose Use Existing List.This is where all the recipients’ details that our labels require such as name, address etc are stored. Next, we will need to select the data source we will be using. Click the Details button and enter the measurements of the label you will be usingĪn outline of the labels will appear in your document.
Select the Label vendor and Product number of the labels you will be using from the lists provided.
If the label you will be using is not shown either: The Label Options dialogue box appears.Click Start Mail Merge and select Labels.This post will walk through generating a mail merge to produce labels from data stored in an Excel spreadsheet. It is a hugely popular and powerful tool. Mail Merge is, in my opinion, one of the best features of Microsoft Word.
0 kommentar(er)
