Word 2007 - Mail Merge & Charts

I've using the Mail Merge feature with Word 2007 reading the data from a Excel 2007 file.

Everything is OK, but one small detail.... the charts are not showing.

Is it possible to use charts with Mail Merge?


Thanks

andremtaAsked:
Who is Participating?
 
GrahamSkanConnect With a Mentor RetiredCommented:
Mergefield data must be a scalar value (e.g. string, date, number, etc), not an object or an array.


You might be able to put a linked chart object on the merge main document and put the mergefield into the field in place of the address.

This would require putting each chart in a separate workbook, and putting the workbook's address into the worksheet column.

The field code would look like this:

{ LINK Excel.Sheet.12 "{ MERGEFIELD ChartAddress }"  "" \a \f 0 \p }
0
 
GrahamSkanRetiredCommented:
Can you explain a bit more, please?

What you you doing in the expectation that Charts should appear?

Normally, Mail Marge will produce a 'page' for each row of the spreadsheet datasource, plugging the scalar value from each column if it has one or more MergeFields on the document for that column. The Mergefield will probably be named after the value in row 1.
0
 
andremtaAuthor Commented:
The Word recognizes all the columns from the Excel.
Although in one column each line has a different chart. The other columns/lines are only text.

That chart is not appearing the in the Word.


0
All Courses

From novice to tech pro — start learning today.