Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2003

Tip: Looking for answers? Try searching our database.

Merge from Excel to Word

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DEG - 20 Nov 2003 22:32 GMT
I am trying to merge a pie chart from Excel into Word by
Employee number. Can anyone help me?
Peter Jamieson - 25 Nov 2003 15:50 GMT
Never done this myself but here is a previous response from fellow MVP Cindy
Meister. I don't know whether it will help slve the specific merge problem
you have:

------------------------------------------------------------
> Is it possible to insert a chart into a mail merge form
> that would change with each record?  Example: in each
> excel record, i am comparing two fields in a pie chart.

It's sorta possible, but a bit painful.

Assuming you've already got the charts in Excel, then the
solution isn't too bad. Each chart will have a designation;
if you created them on separate sheets, it will be the
sheet name. Otherwise, Excel will have assigned an object
name (or you could change this name via VBA).

Whatever. You need to add a column to the merge data table
and enter the chart name for each record.

Set up the main merge document with everything except the
chart.

In Word, a LINK field will take care of bringing in the
chart. In order to generate the basic field, copy/paste
special + link any chart into Word.

Press Alt+F9 to reveal the field codes (Alt+F9 again to
hide them).

Look at the LINK field code: you should see the chart name
near the end, after the path to the file containing the
charts. Substitute the appropriate merge field for the
chart name.

Without hiding the field codes, or doing anything else,
merge immediately to a NEW document. Ctrl+A, F9, Alt+F9
(select all, update the fields, turn off the field codes).
With any luck, you should now see the charts for each
record.
------------------------------------------------------------

--
Peter Jamieson - Word MVP

> I am trying to merge a pie chart from Excel into Word by
> Employee number. Can anyone help me?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.