I am using Word .dot documents now, but would like to find a way to type out all the fill-in information in one place and then click and have all the blanks filled in with this custom information. I am hoping to find a way to do this with VB or something similar.



I did look at those links, and didn't see just what I am hoping to find.

When I use VB now, I create macros to change fonts and that kind of thing.

I'd like to find a way to create a worksheet to enter all my data and then have it all automatically uploaded into the body of a preexisting document, coded for this purpose.

All help greatly appreciated.

That's what those links show how to do...
Can't have looked too hard is all I can say, especially with the last two links...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

When I worked through doing it that way, it was very cumbersome, for what I am trying to do. Not really preferable to just copying and pasting, as far as I could tell. As I say, I am a novice and may be missing something.

I take one of my preexisting documents. Then, several places throughout the document I want to insert new material, some of it just an address, some of it paragraphs long. I have the new material typed on a new Word document worksheet.

Ideally, I would like to find a way to give the worksheet material portions field names or whatever and then have these field names also appear in the preexisting document. Then have a way to just have the program search the preexisting document for the field names, stop at each, and substitute the new material from the worksheet at each place.

In Quattro, I have set up spreadsheets to link this way. Data from a cell in one spreadsheet is automatically loaded into a given cell in another spreadsheet. I'd like to find a way to do this, or something similar, in Word.