How do I address envelopes from a spreadsheet? ...

<p id='intelliTxt'> Merge is a tool that Microsoft Word lets you create mailing labels or print directly on envelopes with a worksheet that you created. ... .Merge is useful when you mail a lot of people have something. ... .When you review the process of mail merge to each of your labels to make sure it is how you want printing completed. ... .Some adjustments may be necessary to look your labels perfect. ... .These instructions are for use in Word 2003. ... .Top tips for information on Word 2007 </ p> difficulty. .. <h2 Class="Heading1a Moderate underlining header"> instructions <ol id='intelliTxt'> <li id="jsArticleStep1"> a <p> Divide. .Spreadsheet in six columns guaranteed. Otherwise merge correctly identifies the parts of each address. ... .Name, address, city, state and zip code must be used as column headings. ... .Customize this list by adding titles (Dr., Mr. and Mrs, for example) are not covered or country, if your address list contains terms of these six positions. ... .Use Excel or Microsoft Word to create your worksheet. ... .Use a table if your addresses in Microsoft Word-list. ... .Save the document so that it can use as a data source. ... .Open a new Word document and the process of mail merge. .. </ P> <li id="jsArticleStep2"> 2 <p> Enter all your addresses in the cells corresponding to each part of the address. ... .A row contains the address of a person. ... .Save this document with a file name, you can easily to find on your hard disk. .. </ P> <li id="jsArticleStep3"> 3 <p> Open your word processor. ... .File, click New, Save As and give your document a file name as you remember. .. </ P> <li id="jsArticleStep4"> 4 <p> Click on Tools, Mail Merge, Create, envelopes and labels. ... .Click Data, Open Data Source. ... .Select the database containing the addresses you create using directly in the file. ... .If the list of addresses is displayed, turn off all the people you want to create a label. .. </ P> <li id="jsArticleStep5"> <p> 5 Select the type of label you want to use to their provider. .Number or size labels. ... .You can also create a custom label by using this option on this screen. .. </ P> <li id="jsArticleStep6"> 6 <p> the "Click to add a merge field .. .A field is the column headers as the first name that you added to your paper. Calculation. ... .Use the space bar and enter the format of each label on the screen. ... .Another possibility is to choose to appear on the screen that contains all the fields in your database. .. </ P> <li id="jsArticleStep7"> 7 <p> Click Merge to new document, all records, Fusion .. ... .Click Edit, Select All to select all labels. ... .Change the text size or color if you do not like how they look. ... .Take a look at your labels by clicking File, Print Preview to look at the first page of labels. ... .Press Page Down key to display all the pages. .. </ P> <li id="jsArticleStep8"> <p> 8 Ensure that the format of each label corresponds to the text. ... .Labels are sometimes cut off on the text of them. ... .Change the font size or alignment of text to individual labels, if you have any problems. .. </ P> ...