I have an Access Application that initiates a Word Mail-Merge using a template and mail-merge fields. Everything has been working fine for some time now, but there are a couple of things I 'd like to tidy up.

WORD 2007 opens up and shows the completely formatted E-mail, without Problems. However when you click Finish & Merge, and then Send E-mail Messages. For some bizarre reason WORD 2007 then displays the Merge to E-mail Dialog Box and insists you re-enter the Subject. (This was NOT needed in earlier versions of Word.)

We'd really like to get this sorted so that the Access VBA can set the 'Subject' to avoid the User having to re-type it. They set it earlier inside Access, so this is a little in-elegant.

However what we'd really like to do is create a dynamic Subject line that can use Mail-Merge Fields to create different 'Subject' Lines for each E-mail, Such as:

"Adam, don't forget Staff Barbeque this Saturday"

Where "Adam" comes from the Mail-Merge Field <>.

I appreciate this would probably involve writing a VBA routine in WORD, but how do I do that? And is there anyway that our Access Application could load that into Word.

BTW we use late-binding, so everything we have going already works with all versions of Access, and Word.