Create a catalog merge

Before you start

The following tips will help you create a successful catalog merge:

• Start the catalog merge in a new publication.

• In addition to pages such as a cover, table of contents, and order forms, give yourself one page for your merge fields, even through your catalog will likely have multiple pages once you create the merged document.

• Set up the catalog merge template with the page dimensions that you want for your final merged pages.

• If you plan to add the merged pages that you create to the end of an existing publication, make sure that your catalog merge template matches the existing publication in the following ways:

  • Page size (height and width)

  • Page view (one-page spread or two-page spread)

  • Publication type (Web or print)

  • Page order (left-to-right or right-to-left)

Top of Page

Plan your data source

After you decide the kind of information that you want to include in your catalog, you can create the data source that you will use for your catalog merge. If you already have a data source, you can make sure that it contains all the information that you want to include in the merge.

Publisher’s catalog merge can use a variety of data source formats. If you don't already have a data source to use for your merge, you can generate one in Publisher. You can also create a data source in a Microsoft Office Excel worksheet or in a Microsoft Office Word table.

The data fields that you include in your data source correspond to the merge fields that you insert into your catalog merge template.

When you set up your data source, create a column for each type of information, such as the item name, the stock number, and the price. Each row, or record, corresponds to the information for one item.

 Important   Make sure that your data source includes a data field, or a column, for each kind of information that you will merge. Depending on the type of your data source, you might be able to make some changes to the data after you connect to it in Publisher, but it's better to finalize the information before you start.

If you plan to merge photos into your catalog pages, you need to include a column for the path of each picture file that you plan to use. Do not include the actual pictures or images in your data source.

If you plan to create your data source in Publisher, you can do that after you create the template publication.

Top of Page

Create the catalog merge template

1. Choose a publication template that is appropriate for your catalog.

2. On the Insert tab, click Catalog Pages.
   

3. Catalog pages will be created with a default Catalog Merge Area and the Catalog Tools tab will appear on the ribbon. At this time you can position the Catalog Merge Areaas you want it on the page and add any text or images that you want to appear on every page of your catalog. The smaller the merge area, the more catalog items can be merged to the page. For example, a 2”x2” merge area will repeat more times than a 4”x4” merge area. Don’t worry too much about getting it exactly right as you can go back and edit these items at any time.

    Tip   Don’t configure the Catalog Merge Area at this time, wait until it’s time to insert the merge fields and use one of the pre-made designs from the Layout gallery.

Top of Page

Type a new list

1. In the New Product List dialog box, type the information for the first item, or record, that you want to include in your catalog.

   If you want to add or remove columns — for example, if you aren't including pictures — click Customize Columns, and then make the changes that you want.

2. After you type all the information for your first record, click New Entry, and then type the information for the next record. Continue until you have typed information for all the records that you want to include.

3. When your new list is complete, click OK.

4. In the Save Address List dialog box, type a name for your new list, and then click Save.

Use an existing list

1. In the Select Data Source dialog box, locate and click the data source that you want.

   By default, Publisher saves data sources in the My Data Sources folder. You may need to browse to the My Data Sources folder to locate your data source.

2. Click Open.

   Depending on the type of data source you select, other dialog boxes may appear requesting specific information. For example, if your data source is an Excel worksheet that has information about multiple tabs, you must select the tab that contains the information you want, and then click OK.

Select from Outlook Contacts

1. Do one of the following:

   • In the Select Contacts dialog box, click the list of contacts that you want to use.

   • In the Choose Profile dialog box, select the correct profile for the contacts that you want to use.

2. Click OK.

Add more lists

If you want to use more than one list in your catalog merge, you can add lists.

1. Click Edit List, and In the Catalog Merge Product List, under Add to product list, click Select an existing list, Select from Outlook Contacts, or Type a new list.
   Publisher will prompt you to fix mismatches between fields in the various source lists by opening the Add to Product List dialog box.

2. In the Add to Product List dialog box, select a field that is not checked in the Matched column, select the field to which you want it to correspond in the Product list fields with matched fields list, and then click Match.

3. In the Match Field dialog box, verify that the field that you selected is listed under Match to a product list field or select another, and then click OK.

4. If you need to add a new field to your recipient list to make a match, select the field that you want to add in the new list (the left list in the Add to Recipient List dialog box), click Add, and then click OK.
   Added fields are shown under New fields to be added to recipient list

Select the records that you want to include

1. Click Edit List.

2. In the Catalog Merge Product List dialog box, do one of the following:

   • Select the check boxes next to the records that you want to include, and clear the check boxes next to the records you want to exclude.

      Tip   If you want to include only a few records in the list, click Clear All, and then select the records you want.

   • Filter your list by a specific criterion by clicking the arrow next to the column heading of the item that you want to filter by and then clicking the value that you want to use as a filter.

     • (Blanks)displays all the records in which the corresponding field is blank.

     • (Nonblanks) displays all the records in which the corresponding field contains information.

        Note   If your data source contains records that share the same information, and there are ten or fewer unique values in the column, you can filter by specific information. For example, if your data source is a list of properties for sale and there are multiple property records that list Buffalo as the city/location, you can filter on Buffalo.

       The Catalog Merge Product List dialog box displays only the designated records. To display all the records again, click (All).

   • Sort items in the list by clicking the column heading of the item that you want to sort by. For example, if you want to display the list alphabetically by city/location, click the City/Location column heading.

3. Click OK.

Top of Page

Select merge area layout

1. In the Layout group, do one of the following:

   • Select from one of the pre-made design galleries.
     

   • Select the number of rows and columns on each page in the Rows and Columns drop-down.
     

Insert text merge fields into the catalog merge area

1. Click the Text Field button, and click the first merge field that you want to insert.
   

2. In the catalog merge area, select the merge field and then move and resize the merge field by doing the following:

   • To move the merge field, position the mouse pointer over the merge field until the pointer changes to the Move pointer , and then drag the merge field to a new position.

   • To resize the merge field, position the mouse pointer over one of the sizing handles on the text box or picture frame until the pointer changes to the Resize pointer , and then drag the mouse until the text box or picture frame is the size that you want.

3. Click outside of the merge field so that it is no longer selected.

4. Repeat Steps 1-3 until you have inserted all of the fields that you want from your data source.

 Important    The fields are inserted at the current insertion point (insertion point blinking cursor). If there is no insertion point, a new textbox will be created and the merge field placed in this new textbox.

Format the text merge fields

You can format the merged catalog data by formatting the merge fields in your catalog merge template. These fields can be treated like any text box and you can include non-merged text and formatting as well as the merged items.

1. In the catalog merge template, select the field containing the information that you want to format, including the surrounding merge field characters («« »»).

2. On the Text Box Tools tab, select the options that you want.

Insert picture merge fields into the catalog merge area

1. Click the Picture Field button, and click the first merge field that you want to insert.

2. In the catalog merge area, select the merge field and then move and resize the merge field by doing the following:

   • To move the merge field, position the mouse pointer over the merge field until the pointer changes to the Move pointer , and then drag the merge field to a new position.

   • To resize the merge field, position the mouse pointer over one of the handles on the text box or picture frame until the pointer changes to the Resize pointer , and then drag the mouse until the text box or picture frame is the size that you want.

3. Click outside of the merge field so that it is no longer selected.

4. Repeat Steps 1-3 until you have inserted all of the fields that you want from your data source.

 Important    The fields are inserted at the current insertion point (insertion point blinking cursor). If there is no insertion point, a new textbox will be created and the merge field placed in this new textbox.

Move or resize the catalog merge area

If your formatted merge fields no longer fit in the catalog merge area, you can resize it.

 Note   If you increase the size, you may need to fit fewer items, or records, on each page.

1. Click the Catalog Merge Area to select it.

2. Position the mouse pointer over one of the handles on the Catalog Merge Area, and then drag the mouse.

3. Specify how many items should appear on each page by typing the numbers that you want for items down the page and across the page on the Catalog Merge Layout toolbar.

Finish and preview the template

1. Click Preview Results.

2. Click the arrows to view each page of merged data.
   

   If you decide not to include an item, click the previewed item, and then click Exclude Entry in the Preview Page group.

Top of Page

Merge to a new publication

If you want to edit your merged pages, save them for later use, or print them at a later time, you can collect and save all of your merged pages as a single new merged publication that contains the actual data — for example, product names and prices — instead of merge fields.

1. In the Merge group, click Merge to New.
   
   Publisher creates a new publication that you can save and edit. You can even add front and back cover pages.
    Note   If you plan to print your catalog as a booklet, make sure that the total number of pages is a multiple of four.

2. In the Catalog Merge task pane, click Save this publication.

3. In the File name box, type a name for your new publication, and then click Save.

4. If necessary, also save any changes that you made to your catalog merge template. You can use this catalog merge template again to create additional merged pages whenever you update the information in your data source.

Add to an existing publication

If you already have your covers set up in a separate publication, or if you want the catalog placed at the end of a longer publication, you can add your merged content directly.

Before you add your merged pages to the end of an existing publication, make sure that your catalog merge template matches the existing publication in the following ways:

• Page size (height and width)

• Page view (one-page spread or two-page spread)

• Publication type (Web or print)

• Page order (left-to-right or right-to-left)

 Note   Publisher cannot add merged pages to an open publication. If you are working on the publication to which you want to merge, make sure that you save and close it before you complete your merge.

1. In the Merge group, click Add to Existing.
   

2. In the Open Publication dialog box, locate and select the publication to which you want to add the merged pages, and then click Open.

   Publisher adds the merged pages to the end of the existing publication.

    Tip   To rearrange the pages in your updated publication, click any page that you want to move on the page navigation pane, and then drag it to the location that you want.

3. In the existing publication, click Save to save your updates.

4. If necessary, also save any changes that you made to your catalog merge template. You can use this catalog merge template again to create additional merged pages whenever you update the information in your data source.

Print your merged publication

• In the Merge group, click Print.
  

  Publisher opens the print page in the BackStage view.

Top of Page