well, we went straight to the steps:
- Open the Microsoft Word application, in this tutorial I am using Word 2007. Choose menu Mailings - Star Mail Merge - Step by Step Mail Merge Wizard . As shown in the following figure.
- The next window will appear Mail Merge task pane, right, select Labels and then click Next: Starting document . At the Mail Merge task pane next, select the Change document layout and then click Label options . As in the picture.
- After the Label Options window will appear. If the type of label that we will print nothing, then we select New Label to set a new label types. As in the following figure.
- Suppose we will print the label as the example below, then we have to make adjustments to the measurements using a ruler to measure and incorporate the Label Details window after clicking OK . look at the picture below.
- After it appeared a new type of label document as shown below. Until this step, we first minimize and then we go to Microsoft Word Microsoft Excel to create data labels recipient.
- Open the Microsoft Excel application to create a database of the identity of the label, say for example we have created a data receiver label as shown below, and we save it with the name "Receiver". For simplicity also change the name on the sheet tab at the bottom.
- Once the data is created and stored, reactivate Microsoft Word and then click Next: Select Recipients as shown above (step 5). The next window will display a task pane select the Use an existing list and then click Browse . In the Select Data Source window, we select data "Receiver" we have created with Microsoft Excel earlier and click Open . as shown below.
- In the Select Table window select sheet " Recipient $ "and then click OK . To further define the people who will be the recipient by way of checking the box and under the then OK again. as shown below.
- If everything is done correctly it will show the documents labeled with a first label empty and the other containing<< Next Record >>. At first Design a label to your liking. Suppose the "To:" we type in manually, for we enter the name of the ribbon Insert Merge Field and select the name and do not forget to address as well. When finished editing the first label ribbon click Update Labels to apply the label to the other, as shown below.
- Furthermore, the suffix appears as shown below. To see the results click Ribbon Preview Result . If the recipient of many label underneath just add page as required and then click Update Labels again.
- For Printing labels fact I've never tried, but approximately to the settings we choose Current Record because we put the receiver on the first record label, unless we want to double that can select another option and click OK . As shown below
- For printing settings, adjust the paper size to the size of the label.
If deemed useful, please tell your friends.
So this tutorial, if there are less obvious can be asked in the comments field. If there is a mistake I apologize. Thank you for your visit all, may be useful.
No comments:
Post a Comment