Completing the merge
Publisher will not let me merge to the publication I selected.
- You might be trying to merge to a publication that is open. Microsoft Publisher cannot add merged pages to a publication that is open. Save and close the publication and try again.
- You might be trying to add merged pages to a publication that does not match your catalog merge template in publication type or page order. If you plan to add merged pages to the end of an existing publication, you must select a publication that matches your catalog merge template in the following ways:
- Publication type (Web or print)
- Page order (left-to-right or right-to-left)
To complete the merge, make any necessary changes to either the catalog merge template or the existing publication, and then merge again. Or, select another publication that matches the catalog merge template in publication type and page order.
- You might be trying to add merged pages to the catalog merge template itself. You cannot add merged pages to the catalog merge template. Select another publication or click Create new publication to save the merged pages as a new publication.
- You might be trying to add merged pages to file that is not a Publisher file. Select a Publisher file.
I can't connect to a data source.
Publisher merged all of the pages to the end of the publication.
The records do not display properly on the page when I add merged pages to an existing publication.
If you complete a catalog merge by selecting the option Add to existing publication, the merged records might not display properly on the pages of your updated publication if the publication that you select does not have the same page size or page view as the catalog merge template.
To achieve the best results when adding merged pages to an existing publication, select a publication that matches the catalog merge template in the following ways:
- Page size (height and width)
- Page view (one-page spread or two-page spread)
To improve the results of the catalog merge, make any necessary changes to the page size or page view of either the catalog merge template or the existing publication, and then complete the merge again.
I have blank records in my merged publication.
- If it is not already open, open your catalog merge template.
- On the Tools menu, point to Mail and Catalog Merge, and then click Mail and Catalog Merge Wizard.
- In the Mail and Catalog Merge task pane, click Next: Select data source.
- Under Select data source, click Edit record list.
- Click the arrow next to the column heading of the item you want to filter by.
- To exclude blank records from your merge, click (Nonblanks) to display all the records in which the corresponding field contains information.
The Catalog Records dialog box displays only the designated records. To display all the records again, click (All).
The catalog merge area does not repeat on the page in my merged pages.
There are extra pages mixed in with my merged pages, and the catalog merge area does not repeat on the merged pages.
- If there is more than one page in your catalog merge template, you might have completed the merge while displaying a page that does not contain the catalog merge area. The catalog merge area must be in view when you complete your merge. For best results, limit your catalog merge template to one page.
Some of my merge fields do not repeat and they do not contain any information from my data source.
- You might have inserted merge fields outside the catalog merge area. Any merge fields inserted into your catalog merge template outside the catalog merge area will not merge data or repeat on the page. Any merge fields that partially overlap the border of the catalog merge area also will not repeat on the page.
Merged text and objects
My merged data lost its text formatting.
- Select the merge field that you want to change.
- On the Format menu, click Font.
- In the Font dialog box, select the options that you want.
My data gets cut off in my merged publication pages.
All of my data runs together in my merged publication pages.
The color of text, lines, or objects changes when I merge to an existing publication.
- In your catalog merge template, select the text, line, or object to which you want to apply a non-scheme color.
- On the Formatting toolbar, do one of the following:
Select the options that you want.
- To apply a non-scheme color to text, click the arrow next to Font Color , and then click More Colors.
- To apply a non-scheme color to a line, click the arrow next to Line Color , and then click More Line Colors.
- To fill an object with a non-scheme color, click the arrow next to Fill Color , and then click More Fill Colors.
There are file names or paths instead of pictures in my merged pages.
- If it is not already open, open your catalog merge template.
- On the Tools menu, point to Mail and Catalog Merge, and then click Insert Field.
- Delete the existing merge fields you want to replace.
- In the Mail and Catalog Merge task pane (Step 3: Create your catalog merge template), point to the field that you want to insert as a picture, click the arrow on the right, and then click Insert as Picture.
Publisher inserts a merge field within a picture frame into the Catalog Merge Area.
- Repeat Step 4 until you have inserted all of the fields that you want from your data source.
My pictures do not appear in my merged pages.
- Open the data source file that contains the information you want to update; for example, a Microsoft Excel worksheet.
- Create a new column or data field (data field: A category of information that corresponds to one column of information in a data source. The name of each data field is listed in the first row (header row) of the data source. "PostalCode" and "LastName" are examples of data field names.) for each picture type that you want to include.
- Type a unique column heading or name for each picture data field that you create.
These names will become the names for the merge fields (merge field: A placeholder for text or pictures that you insert into your publication. Information from a data source (such as a name, address, or image) is inserted in each merge field. You can format, copy, move, or delete a merge field.) that you select when you create your mail merge or catalog merge. You should make sure that each name is unique so that you can determine which pictures each field represents.
- In each of the picture fields for each of the records in your data source, do one of the following:
When you have finished adding picture information to your data source, save your updated data source file.
- If you plan to save your picture files and your data source in the same folder, type the file name for the relevant picture. For example: firstphoto.jpg.
- If the pictures files will be located in a different folder from the data source, type the path for the relevant picture. For example: C:\Documents and Settings\Username\My Documents\My Pictures\Catalog Project\firstphoto.jpg.
Note You can merge only one picture per merge field. If you want to merge multiple pictures for each record in your data source, you will need to add another column or data field per record to your data source for each of the pictures that you want to use.