Importing text from excel

  • Thread starter Thread starter Olaf Mackenzie
  • Start date Start date
O

Olaf Mackenzie

I have a standard contract. In it i need to input the
same information over and over again. I'd like to set up
a spreadsheet and key in the information there and then
link hte cells to the contract so that it can be filled
in automatically.
When i cut and paste special i get all sorts of layout
changes that i don't want.
Is there an easy way of achieving this?

Olaf
 
If you paste special as an Excel Worksheet Object with the link option set,
provided there is enough room for the selected part of the table it should
come across exactly as portrayed in Excel complete with formatting.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Maybe you'd have better luck setting this up as a mail merge main document.
Even with just one record to merge, it might be simpler.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Back
Top