Solved

Word 2007 - Mail Merge & Charts

Posted on 2010-08-19
4
1,000 Views
Last Modified: 2012-06-21
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

0
Comment
Question by:andremta
  • 2
4 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 33474511
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
 

Author Comment

by:andremta
ID: 33474555
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
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 33477247
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

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question