Using a mail merge document control data

[BruDe]

I have a form that is used to insert a company name and
address into several text form fields. But the problem is
keeping the records upated. So I was wondering if there
was a way to use either an access database, excel
spreadsheet to keep the names and addresses current, and
have word call the other program to select the name,
including any new names that have been added.

 

[macropod]

Hi BruDe,

You can use a LINK field in Word to do this. Perhaps the easiest way is to
open both the Word document and Excel spreadsheet, then copy the cell you
want to link to. Next, switch to Word and choose Edit|Paste
Special|Formatted Text(RTF), click on the 'Paste Link' button, then press
OK. No vba required.

Note that if you select more than once cell at a time, the pasted result
will be a Word Table, and converting the table to text will only work until
the next update - at which point it will revert to a table again.

Cheers