?
Solved

Word 2007 - Mail Merge & Charts

Posted on 2010-08-19
4
Medium Priority
?
1,019 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
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 …

771 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