I have a problem that I am hoping someone can help me solve...
I have an Excel Document with about 5000 records. I am needing to write a letter in Word and use data from the Excel database in the document. Easy enough, the problem is this: I must include 2 pie charts on the document based on data from the Excel sheet. That is to say that just like the address and numeric data varies from letter to letter after the merge, the pie charts must be variable by record and each page of the Word document have its own, unique pie chart after the merge. I can do this in VB or in Fox, but my client MUST do this in Word and Excel. That is all that they have and they basically just want me to train them on how to do this. I am pretty sure that it can be done, even Microsoft's tech support said that it can be done, but I have yet to see it.
Any help will be greatly appreciated.
Thanks,
Mark.
I have an Excel Document with about 5000 records. I am needing to write a letter in Word and use data from the Excel database in the document. Easy enough, the problem is this: I must include 2 pie charts on the document based on data from the Excel sheet. That is to say that just like the address and numeric data varies from letter to letter after the merge, the pie charts must be variable by record and each page of the Word document have its own, unique pie chart after the merge. I can do this in VB or in Fox, but my client MUST do this in Word and Excel. That is all that they have and they basically just want me to train them on how to do this. I am pretty sure that it can be done, even Microsoft's tech support said that it can be done, but I have yet to see it.
Any help will be greatly appreciated.
Thanks,
Mark.