Mail merge from excel to word 2013 labels update#
Click Update Labels, the changes will propagate to all your other labels.From the ribbon click the Mailings tab.hyperlink (this may not be as easy as it seems depending on the size of your labels). Add the rest of your fields using the More items.Now when the label has a second line address it will appear and when it does not have a second line address an additional line will not appear. Put your cursor between the second to last bracket and the last double quote, hold Shift+Enter.In the Field dialog from the Field names: double click IF.
From the ribbon bar click the Insert tab.Click the hyperlink More items, and in the resulting window double click the fields you need until you get to the second line of the address.Click the hyperlink Next: Arrange your labels.Make sure all the rows of data with checkboxes next to them are rows that you want in your labels.Pick the worksheet that your mail merge data exists on.Click the radio button Use an existing list.Click the hyperlink that reads Next: Select recipients.Select the type of label or equivalent type of label you are using.Click the radio button Change document layout.Click the hyperlink which reads Next: Starting document.Click Step-By-Step Mail Merge, the Mail Merge wizard will appear in the right hand panel.Click the Start Mail Merge dropdown button.In the ribbon bar click the Mailings Tab.Oh okay so it is working right.Microsoft can't make their previews work right in the Mail Merge for 2007, so here is what I did:
0 kommentar(er)
