I have a user form and some code in an excel file that creates a word document (known as MyNewWordDoc.doc). The user form asks the user whether they want to use e-mail or snail mail to send the letters the code generates. If they choose snail mail, the user is then required to enter their address.

What I want to do next with it is call up mail-merge, insert a field for the First Name from the Outlook Contacts address book into the document and then let the user choose the contacts to whom the letter is to be sent (or e-mailed) and where the user has chosen e-mail, use the recipients’ e-mail addresses.

I’m just not too sure how to go about this. How do I call up mail merge – or otherwise use Outlook contacts to solve this problem?

Thank you