Home |
Search |
Today's Posts |
#1
|
|||
|
|||
mail merge with excel charts
Hi,
I am having a problem trying to mail merge excel charts into a word document. I have created a number of charts in excel, along with a table of the chart names. I have created a mail merge doucument with the line { LINK Excel.sheet.8 "c:\\data1.xls" "Sheet1![data1.xls]Sheet1 {MERGEFIELD "aa" }" \a \p } If I press shift F9 in the pre-merge document, a chart is displayed. When I merge the document and select all and shift F9 the same chart is displayed on each page, even though the line above shows the individual chart numbers e.g. chart1, chart2 etc. When I save the file and then relaod it I get "error! Not a valid link" when I select all and shift F9. Does anyone have any suggestions ? Thanks |
#2
|
|||
|
|||
Hi ?B?R2FyZXRo?=,
Depending on the version of Word, sometimes the LINK field will convert any embedded field codes into static text as soon as you even toggle the field codes. My advice would be to set up the LINK field (again, from scratch), the execute the merge *immediately*. In the result document, Ctrl+A, F9, and only then Alt+F9. I am having a problem trying to mail merge excel charts into a word document. I have created a number of charts in excel, along with a table of the chart names. I have created a mail merge doucument with the line { LINK Excel.sheet.8 "c:\\data1.xls" "Sheet1![data1.xls]Sheet1 {MERGEFIELD "aa" }" \a \p } If I press shift F9 in the pre-merge document, a chart is displayed. When I merge the document and select all and shift F9 the same chart is displayed on each page, even though the line above shows the individual chart numbers e.g. chart1, chart2 etc. When I save the file and then relaod it I get "error! Not a valid link" when I select all and shift F9. Does anyone have any suggestions ? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2003 Small Business - Mail Merge from Excel Sheet Duplication Oddi | Mailmerge | |||
Mail merge using an excel file | Microsoft Word Help | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Include linked graphs from Excel during mail merge? | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |