You seem to want to create a lot of work for something that can be handled with no code via a very ordinary mailmerge using Word.

What you're asking for would require a fairly complex macro, to automate and populate an embedded Word document (so it's not using just 'a function in excel', anyway), for little practical benefit.

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