Solved

Word 2007 - Mail Merge & Charts

Posted on 2010-08-19
4
999 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction This tutorial provides instructions on how to properly format your Word document using the inbuilt tools provided. The benefits of using these tools means your documents are more accessible and easily portable to other applications an…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

861 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now