Microsoft KB Archive/113445

{|
 * width="100%"|

How to Include a Microsoft Excel Chart in a Mail Merge

 * }

Q113445

-

The information in this article applies to:


 * Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
 * Microsoft Excel for Windows, versions 3.0, 4.0, 5.0

-

SUMMARY
To include a Microsoft Excel chart in a Word for Windows mail merge operation, use a DDEAUTO field.

MORE INFORMATION
If you want to perform a conditional merge with a Microsoft Excel chart, you can use the DDE field and the IF statement if that chart is not in the main document.

A sample syntax for the IF statement and the DDEAUTO field using Microsoft Excel 3.0 or 4.0 is as follows:

  {IF {MERGEFIELD JobTitle} = "president" {DDEAUTO Excel CHART2.XLC \*MERGEFORMAT}} The syntax for the statement using Microsoft Excel 5.0 is:

  {IF {MERGEFIELD JobTitle} = "president" {DDEAUTO Excel.Sheet.5 "C:\\excel\\sheet.xls" "chart" \p} Chart represents the name of the chart in the Microsoft Excel workbook.

This statement includes the Microsoft Excel chart only if MERGEFIELD JobTitle is equal to "president"; if it is not "president," the chart does not appear in the document.