Merge Signed Name with airSlate SignNow

Merge signed name

hello and welcome to the point from nav attend in this screencast we'll look at making address labels with mail merge let's get started first create a list of addresses in an Excel spreadsheet make sure that the columns are clearly labeled with first name last name address city state and zip headings to start the mail merge open a blank document in Microsoft Word and select the mailings heading then click start mail merge labels in the dialog box that opens choose your label vendor of choice and a product number then click OK Microsoft Word will format the labels automatically to import the addresses onto the labels click select recipients use existing list select the Excel spreadsheet you created earlier and click open in the dialog box that opens select the correct sheet click OK while the cursor is in the first empty label click insert merge field and insert the necessary fields make sure that there are spaces commas and line breaks between the merge fields when necessary also apply any desired formatting at this time to apply these merge fields and the formatting across the entire sheet click update labels the page may look a little messy but it should be fine click preview results to make sure that the addresses in the spreadsheet were imported correctly click finish and merge edit individual documents then select all and click OK the new document that opens labels 1 is the document you will actually print onto the label sheet labels 1 maintains the formatting of the previous document but does not allow you to change the mail merge settings when saving the original document name it something like address label template so you can use it again however remember to select recipients again the next time you use it if you have updated your Excel address sheet if you have an unanswered technical question that you would like to see appear in an upcoming issue of the point feel free to email it to social I have attend com with that we reach the conclusion of the screencast you can watch previous issues or subscribe to receive the point via email on our website the link is below have a great week