Question Locked

Mail Merge the right app?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
My CFO wants to add a pie graph to the bottom of a Word document taken from information in an Excel spread sheet. It is a letter to employees with an explanation of benefit costs. This information will be pulled from actual employee records imported to Excel. Automating the process would save tyoing the info near 500 times. It has been suggested that using mail merge to pull employee information to automate printing of the letters. Keeping in mind they want the pie graph updated with individual records. Is this possible?

2 replies

by rtunnell

Merging into MS graph is not easy. But, another solution I just posted is how we used to build these applications before acquiring some specialized software. Simply create the benefit statement on a seperate worksheet of the same Excel file. Then create a third worksheet to hold one row of data from your data file. Then, link the charts of the statement to the data cells on this 3rd sheet. Write a VBA routine to recurse the data sheet copying one row of data to the 3rd sheet, then execute a print command. 949-253-7502 if you have questions.

Ray

This discussion is closed to new replies.