M
Mark Freeze
I am having a problem with Word that I cannot solve. I
have an 8.5x14 sheet on which I have printed a long
letter with about 20 merge fields across 4 paragraphs.
It is working nicely and my customer prints about 12 to
50 of these per day. The problem comes about when
attempting to insert a pie chart at the bottom of the
letter that varies based on data within the merge. For
example, each customer has 4 amounts in each record. A
stock-invested amount, a bond-invested amount, an other-
invested amount and a total-invested amount. What I need
to do is have each page of the merge have a unique pie
chart with slices representing the stock, bond, and other
amounts as a percentage of the total amount. The customer
HAS to print this at his office and all he has is Word
and Excel. Right now, he is inserting a unique chart
onto each letter manually after the merge has been
completed. This works for 12 letters, but is a real pain
when the end of the month 500 letters comes along.
Anyone have any ideas?
Thanks,
Mark.
You can also email me at (e-mail address removed)
have an 8.5x14 sheet on which I have printed a long
letter with about 20 merge fields across 4 paragraphs.
It is working nicely and my customer prints about 12 to
50 of these per day. The problem comes about when
attempting to insert a pie chart at the bottom of the
letter that varies based on data within the merge. For
example, each customer has 4 amounts in each record. A
stock-invested amount, a bond-invested amount, an other-
invested amount and a total-invested amount. What I need
to do is have each page of the merge have a unique pie
chart with slices representing the stock, bond, and other
amounts as a percentage of the total amount. The customer
HAS to print this at his office and all he has is Word
and Excel. Right now, he is inserting a unique chart
onto each letter manually after the merge has been
completed. This works for 12 letters, but is a real pain
when the end of the month 500 letters comes along.
Anyone have any ideas?
Thanks,
Mark.
You can also email me at (e-mail address removed)