How to create labels in Word, Excel ...

<p id='intelliTxt'> Microsoft Word mail merge, you can communicate with Excel and create labels from existing data. ... .Even if you do not have to create the table, you should take your Excel spreadsheet column headings in the preparation of the merge. ... .This makes it easier to identify the data fields. ... .If your workbook contains multiple worksheets, you can use the worksheet that you want to specify Word shoot. ... .Completed labels can be added on your page or print it immediately </ p> difficulty. .. <h2 Moderately easy class="Heading1a Underline header"> instructions <ol id='intelliTxt'> <li id="jsArticleStep1"> 1 <. .P> Open the worksheet that you want. In Microsoft Excel. .. </ P> Header <li id="jsArticleStep2"> <p> 2 Insert a column above each column if none exists. ... .To add a row of the right mouse button on the header in the first line and select Paste from the popup menu. ... .Then type a header on each column of data. .. </ P> <li id="jsArticleStep3"> <p> 3 Save and close the worksheet in Excel. .. </ P> <li id="jsArticleStep4"> <p> 4 .Open a new document in Microsoft Word. ... ."Mail" and select "Start Mail Merge" Start Mail Merge "from the group. ... .Select labels "Step by Step Mail Merge Wizard, the Wizard in the task pane on the right </ p> <li id="jsArticleStep5"> <p> 5 Select the open" and click. ."Next" .. .. Original document. ."Select" Use the current document and click Set Up "labels .... .. OK "Select the details of your labels in the" Label Options "and click OK </ P> <li id="jsArticleStep6"> 6 <p> Click" Next: .. .Select Recipients "in the wizard. ... .Select "Use an existing list, and click the Browse button to display the" Select Data Source "window to open. ... .Find and double-click the Excel spreadsheet with your list. ... ."Select Table" dialog box appears. .. </ P> <li id="jsArticleStep7"> 7 <p> Select the worksheet you want to use. ... .Check the ". First row contains column headings" </ P> <li id="jsArticleStep8"> 8 <p> Click "OK" to load;. Mail Merge Recipients dialog box .. ... .All recipients will be selected. ... .Clear all the recipients that you be removed from the mailing list, and click OK. ... .A load model label on your page </ p> <li id="jsArticleStep9"> 9 Click <p>. .. Next: Arrange your labels in the wizard. ... .Click Insert similar items ...." The "Merge Field dialog box loads. ... .Select and set the fields you want to include in your tag and click Close. .. </ P> <li id="jsArticleStep10"> <p> 10 on the first label on your side to keep the labels go. ... .To add a space between the fields Name, click in between the two fields and press the space bar. ... .Over the company name on another line, place the cursor immediately before the field of economic and press "Enter". .. </ P> <li id="jsArticleStep11"> 11 <p> Back to assistance once your labels are positioned correctly. ... ."Update all labels" button to reproduce the pattern for other labels on your side. ... .Click on "Next: Preview your labels" and "Next. Complete the merge" </ P> <li id="jsArticleStep12"> 12 <p> Click "Print" ."Edit individual labels" on. print labels immediately or. .Ad on your page. ... .The "Print" or "Merge to New Document dialog appears. ... .Select "All" to merge all records and click OK. .</ P> ...