Could you post the template letter so that we can see what you already have?!

Thanks for your help!

Attached Files

Application Response Letter 2.doc (28.0 KB, 35 views)

I have created a form that opens with the document - it has sections for name and address. You use the tab button to move through the boxes and click OK to enter the data into the document.

It has a clear button to empty the data boxes, and a cancel button to enable the user to alter manually if they wish!


To make something like this all work, you add bookmarks to where you want the text boxes to enter the data (you can add in as many added boxes and bookmarks as you like), then tell the form to enter the data at the bookmark location/s of your choice!

If you need any help understanding the VBA script, then just add your questions to this thread so that others can see them!

Attached Files

Application Response Letter (Automated).doc (44.0 KB, 52 views)

Sorry, maybe I am doing something wrong. The document opens with the control toolbox shown, but nothing else. I don't see where to add the information to the form. I can show the address form in the VBA code & know it's there - but I don't know how to pull it up?

Thanks for any and all help!

Yep...my fault. I did not save it as a template. As soon as I did, the form opened for me beautifully. It works great, and I am looking into learning how to code it myself. Thanks so much! Will be sure to up your rep!

Am I able to bring the form back up again? I can't seem to do that. I want to be able to enter the information, print the page, re-open the form, clear the information and start all over. Sorry, I've kind of went all over to figure this out & just came back here.

Are you looking for it to print on close and then open a new form?
I'm a bit busy right now - but I could alter it to do that in the morning and post it then if you want?