Q113445 - How to Include a Microsoft Excel Chart in a Mail Merge

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.

REFERENCES

Online Help: DDEAUTO Field

Additional query words: 6.00a 6.00c including embed embedding link word6 winword linking Print Merge excel officeinterop

Keywords : kbprint kbmerge
Issue type : kbhowto
Technology :