Hi there,

I have a draft letter around 12 pages (legal) in which I have to type the name and address of the applicant, almost on on every page.

Isn't there a way to type the name and address once and it gets placed every where, at the required place.

Thanks in advance

John

The best way to do this is to create a simple userform http://www.gmayor.com/Userform.htm which collects the variable data and inserts it into the required places in the document using bookmarked locations. You will find a handy function for filling bookmarks with values from the userform at http://www.gmayor.com/word_vba_examples.htm

Variable data can be read from a data source (or sources), ideally Excel worksheet(s), or it can be typed into a text field. The examples in the first link used typed data. For more on filling list boxes from external data see http://www.gmayor.com/Userform_ComboBox.html

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Hi gmayor,

Thanks for the answer. Its exactly what I was looking for.

Thanks a lot again


John