1 / 10

Mail Merging in Microsoft Publisher

Mail Merging in Microsoft Publisher. Creating labels and documents for multiple people at once. Preparing Database. Headers. Close. Create a list of names, addresses and phone numbers, etc. in Microsoft Excel . Remember: Put headers at the beginning of each column

tanner-hickman
Download Presentation

Mail Merging in Microsoft Publisher

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Mail Mergingin Microsoft Publisher Creating labels and documents for multiple people at once

  2. Preparing Database Headers Close • Create a list of names, addresses and phone numbers, etc. in Microsoft Excel. • Remember: Put headers at the beginning of each column • Start in Row 1 and Column A • Save when complete • Close Spreadsheet

  3. Create Document • Open Microsoft Publisher • Create the appropriate document • Labels • Business Cards • Documents Double Click to open a new document.

  4. Delete any texts or items not needed Before After

  5. Merging Information • Publisher 2007 • From the Tool menu, select Mailings and Catalogs/Mail Merging • Select Use Existing List • Publisher 2010 • From the Mailings tab, click the Mail Merge Button and Select Mail Merge. • Click the select recipient button and select use existing list.

  6. Locate the Excel document with appropriate data • Click Open • Select the appropriate sheet, and click open

  7. Fourth step: • Publisher 2007 • Click in the text box until the cursor appears • Click on the appropriate header Publisher 2010 • Click in the appropriate box until the cursor appears • Click on the MailingsTab • Click on Insert Merge Field button • Select the appropriate header

  8. Click the preview results to see actual information Move to next record

More Related