Once you've set up the mailmerge and you save the mailmerge main document, it will automatically look for its data source every time you open it. All you need to do is to answer 'Yes' to the initial mailmerge prompt, then click 'Finish' to generate a new output.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Ok I have set up a mail merge with the excel file as a database in the style I need. I saved it as a word template and shutdown. I changed the data in the excel file reopened the word template and said 'yes' but it had all the data from the original template. What am I doing wrong please?