Sunday, September 22, 2013

How to Mail Merge Address Labels in Microsoft Word 2007


1. Click on the 'Mailings' tab in a new Microsoft Word 2007 document. Choose the 'Start Mail Merge' option from the 'Start Mail Merge' group.
2. Click 'Labels.' A dialog box will open. Choose your printer's specifications from the drop-down menus. Enter the brand and product number of the labels you will use. Click 'OK' when you are finished.
3. Return to the 'Start Mail Merge' group and choose 'Select Recipients.' Choose the link that corresponds with the location of your address list. Choose 'Select from Outlook Contacts' if your list is in Outlook; 'Use Existing List' for Excel, Access or another data file; or 'Type New List' if you have not created your address list yet.Enter your addressee information in the form that appears after you select 'Type New List.' Save this file for future use. It will be saved with the database file extension MDB.Locate the file when the 'Select Data Source' dialog box appears after you click 'Use Existing List.'
4. Return to the 'Start Mail Merge' group and choose 'Edit Recipient List.' The Mail Merge Recipients dialog box will appear. To filter by a certain criteria, click 'Filter' under 'Refine recipient list.' The Filter and Sort dialog box will appear. Under the 'Filter Records' tab, choose your filter criteria. For example, choose 'City,' in the 'Field' list, 'Equal to' in the 'Comparison' list and 'Santa Monica' in the 'Compare to' list. This will limit your label results to only those on the list that have a Santa Monica address.
5. Click in the first label in your main label document. Click on the 'Write & Insert Fields' group on the 'Mailings' tab. Click on each field in the tab in the order you want it to appear on your label. For example, click 'Address Block.' When you have entered all of your fields, click 'Update Labels.'
6. Preview your results by visiting the 'Preview Results' group of the 'Mailings' tab. Click 'Preview Results' to review your label results before you print them. To change any of the individual labels, visit the 'Finish' group in the 'Mailings' tab. Click 'Finish & Merge' and then 'Edit Individual Documents.' When you are finished editing, click the 'Microsoft Office' button and then 'Print.'
7. Print your completed labels without making edits. Visit the 'Mailings' tab and go to the 'Finish' group. Click on 'Finish & Merge' and then 'Print Documents.'
8. Save the label main document if you plan to use it again. This document will remain linked to the data file you specified.
 

Blogger news

Pageviews past week

About