apgmin
Board Regular
- Joined
- Mar 1, 2010
- Messages
- 150
- Office Version
- 2013
- Platform
- Windows
Hello!
Introduction : I need to make the blood test report of my patients. I routinely use a set of data which is saved in excel 2010 and mailmerge it in word.
Example : Column A has the patients names, Column B has the RBC count, Column C has the WBC count and so on and so forth. So the mailmerged word report has the report format and I just print the report after feeding the data in the excel sheet mentioned above.
Requirement : Can I also print the bar chart ( Or any other chart ) I have made in the excel file through mail merge in the word2010 report format and get it to change for the next record automatically like the other data in the mailmerge sheet in word.
Current procedure : Now I just print the report first in mail merge in word and then again print the chart again from the excel file on the same paper.
Scared of : Printing a different chart for a different patient report.
Will need a add in or template if possible for say 10 patients and 4 columns
Thank you in advance
Introduction : I need to make the blood test report of my patients. I routinely use a set of data which is saved in excel 2010 and mailmerge it in word.
Example : Column A has the patients names, Column B has the RBC count, Column C has the WBC count and so on and so forth. So the mailmerged word report has the report format and I just print the report after feeding the data in the excel sheet mentioned above.
Requirement : Can I also print the bar chart ( Or any other chart ) I have made in the excel file through mail merge in the word2010 report format and get it to change for the next record automatically like the other data in the mailmerge sheet in word.
Current procedure : Now I just print the report first in mail merge in word and then again print the chart again from the excel file on the same paper.
Scared of : Printing a different chart for a different patient report.
Will need a add in or template if possible for say 10 patients and 4 columns
Thank you in advance