Automatically Change Text from a Data Source

[nma]

I have a number of documents that all have the same information that needs
changing regularly, i.e. client name, date of event, type of event etc. I
have tried using a link with Excel to update the information but this only
seems to work for headings and not in sentance text (becuase it places an
Enter both before and after the imported text). Is there another way that I
can have specific information in one location and use this information to
update general documents automatically?
Please help!

 

[Peter Jamieson]

It depends on what you link, and how you link it (and possibly on the
version of Word)

When you paste into Word, if you use Edit|Paste Special (or in Word 2007,
the Home tab|Paste|PasteSpecial) and select Paste Link you should see a
number of options.

If you paste link|Unformatted text or Unformatted Unicode text you should
see text, with tabs if you paste more than one column and paragraph marks
for each row if you paste more than one row. That's probably what you need.

If you use any of the other options to paste more than one cell, you will
either get a table, which means that Word will surround it by paragraph
marks, or an image, which probably will not align properly.

If you just paste one cell, the Formatted text (RTF) option will probably
also be OK and will preserve some types of formatting.