Solved

Word 2007 - Mail Merge & Charts

Posted on 2010-08-19
4
1,003 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

697 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