Check out my reply to this post here and you should find most of the answers that you require - you can add more yes/no options, or use some of the other VBA commands to create a template that opens and gives the user a range of choices which will auto fill the document - If you need any further help - I'll keep an eye on this thread and chip in if needed!

God luck, and have fun with your first sojurn into VBA.