Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Publisher
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Create a Membership Directory or Phone List in Publisher 2000
 

You can publish a membership directory or phone list with Publisher 2000. First, design how one listing will look in your directory or phone list. Then, use Mail Merge in Publisher to create listings for each person in your address list.

The following procedure assumes that you have the data already available in another Microsoft Office program, such as Excel, Word, Access, or Outlook. If you don't, you can create a list using the Publisher Address List.

To design the listing

  1. If the Catalog is open, click Exit Catalog.
  2. On the File menu, click Page Setup.
  3. Click Labels, and then choose a label with the dimensions you want for each listing in your directory.
  4. Click OK.
  5. To explore your design options, in the Quick Publication Wizard pane, click Design, Color Scheme, or Layout.
  6. On the Objects toolbar, click the Text Frame Tool, position the mouse pointer where you want the text frame to appear, and drag the mouse diagonally until the frame is the size you want.
  7. Type a sample listing that is as long as the longest listing in your data, and then adjust the formatting and position of the text.
  8. On the File menu, click Save.

To merge an address list with the listing you designed

  1. On the Publisher Mail Merge menu, click Open Data Source.
  2. If your address list is in an Outlook contact list, click Merge from an Outlook contact list.
    -Or-
    If your address list is in Excel, Word, Access or a Publisher Address List, click Merge information from another type of file.
  3. Open the file that contains the data for your directory.
    If necessary, change the file type to match the file where your address list is stored.
  4. If prompted Do you want to use the entries in the first row of your data as field names?, click Yes or No depending on how your data is organized.
  5. Highlight the sample first name in the listing design.
  6. In the Insert Fields dialog box, click the first name field, and then click Insert.
  7. Repeat steps 5 and 6 for each field in the listing.
    Make sure to insert a space between first and last names, and press RETURN between fields that you want on separate lines.
  8. Click Close.
  9. On the Mail Merge menu, click Merge.
  10. Preview your listings, and then click Close.
  11. On the File menu, click Save.

After previewing your listings, you may want to adjust your formatting and layout. To preview your listings again, click Show Merge Results on the Mail Merge menu.

To print your directory

  • On the File menu, click Print Merge.

Note  You can only use these procedures to produce a printed publication. They cannot be used to produce a Web page.

For More Information

For help using Publisher to merge a name list with the directory design or to create a Publisher address list, click Microsoft Publisher Help on the Publisher Help menu, and then type mail merge or create a Publisher address list in the Office Assistant or on the Answer Wizard tab.



advertisement