How to Include a Microsoft Excel Chart in a Mail Merge

ID: Q113445

6.00 6.00a 6.00c WINDOWS

The information in this article applies to:

Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
Microsoft Excel, 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.

REFERENCES

Online Help: DDEAUTO Field

KBCategory: KBSubcategory: kbmerge Additional reference words: 6.00 6.00a 6.00c including embed embedding link word6 winword linking Print Merge excel officeinterop

Keywords          : kbprint kbmerge 
Version           : 6.00 6.00a 6.00c
Platform          : WINDOWS
Issue type        : kbhowto

Last Reviewed: February 6, 1998