mailmerging a graph into word from excel...

[funkylad20]

I need to input data into a word report. I mailmerge this data using excel, however there are graphs that I have created in excel which need to be in the word report too. Aside from copy and pasting from excel to word each time, is there a way around this? I need to be able to generate 3 reports a year, from data that I input into the excel sheet each term...

[crossroads]

You might need to do some tweaking with this as its based on databases rather than spreadsheets but same theroy.

[Haggisdj]

I vaguely remember something about Edit -> Paste Special. When you update the excel spreadsheet the next time you open Word it will update the grid / chart...