Hi rene,

OK, you make a new Word template, with mergefields in it. I assume this has a '.dot' extension and, when the user double-clicks on the template, that creates a new mailmerge main document.

So far all the user has is a mailmerge main document, with all the mergefields in place. The user then needs to click on the 'Merge' or 'Finish & Merge' buttons to execute (finish) the merge. Only then will the fields update correctly. What the user will then get is a mailmerge output document with all (or however many they choose) records from the database.

If that is not what you want and, instead, you want to give the user a template with only one merge record in it, then you need to finish the merge and output only the one record that you require. It is the merged output document, not the mailmerge main document you've been working with, that you then save as the template.

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