In the pop-up window, create a file name and save to either your “MyAvery Online Account” or your computer. Click the green Browse for File button to locate the file from your computer that contains your mailing list. Then, select Import Data (Mail Merge) from the column on the left, and click the Start Mail Merge button. To save your design, click the “Save” button. Click the text box where you would like the mailing address to appear on your label.
#CONVERT EXCEL MAILING LIST TO WORD FOR LABELS HOW TO#
The remaining steps will show how to create the mail merge in Word to create envelopes. The steps above created a workbook containing a table of addresses on one sheet that has a name (Addresses) defined that corresponds to the table range. TIP: Follow the directions from the insert in the package for basic printing tips. Save your workbook (Addresses.xlsx) and you are now ready for the mail merge.
The type of mailing list I receive the most questions about is a collection of friends and family to whom a person wants to. This tutorial is intended for Microsoft Office 2007 users who have a list of names and addresses for which they would like to print adhesive mailing labels. When your design is ready to go, just click the green “Print” button. Printing Mailing Labels with Excel 2007 & Microsoft Word 2007. To make adjustments, just click the “Back” button in the upper-right-hand corner. Step 7: Preview & PrintĬlick “Preview & Print” to review your design. The Sheet Navigator on the right will also show you how the entire label sheet will appear. When you are satisfied with the appearance of your labels, click “Complete Merge.” You will see a sample of the first label with your information merged in with your design template. You can insert commas, spaces, and other text, and these will remain where you insert them during the merge. To do this, just click the field name in the “Available fields” list on the left, hold the mouse button down, and drag the field over to the “Arrange fields” box on the right. Now it’s time to set up the appearance of your information as it will look on the labels. If you used the first row of your file for column headings and do not wish to print it out, just click to remove the check mark from “Print this row of data.”Ĭlick “Next” to continue. If you don’t have a spreadsheet with all of your names and addresses, you can start with our pre-formatted files for Microsoft® Excel or other database programs. The file name will appear above the view area. Once it’s located, you should be able to view your file content on the screen. Step 5: Select a FileĬlick the green “Browse for File” button to locate the file from your computer that contains your mailing list. Then, select “Import Data (Mail Merge)” from the column on the left, and click the “Start Mail Merge” button.
Now it’s time to bring your mailing list (or other list) and combine it with your label design.Ĭlick the text box where you would like the mailing address to appear on your label. Want to start from scratch? Choose the “Blank and Text Only” theme. Select from a variety of design themes from the column on the left, and view the design(s) from each theme on the right. Go to Avery Design & Print Online and enter the product number of your labels (such as “5160”) and press Enter Step 2: Confirm the Product TemplateĬlick the template that matches your product.
0 kommentar(er)
