Results 1 to 2 of 2
Thread: Word Importing Excel Data (2003)
2008-05-05, 20:12 #1
- Join Date
- Jul 2007
- United States
- Thanked 0 Times in 0 Posts
Word Importing Excel Data (2003)
I am trying to design a formatted Word document that has variables which are populated from an MS Excel table (that was populated by a form). I have read about dynamically linking Word and Excel so that edits in Excel are reflected automatically in Word. What would it take to import data into a formatted MS Word form that wold leverage the MS Excel form data? Are there any example postings you are aware of that might be a useful starting point to play with?
2008-05-05, 21:09 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Word Importing Excel Data (2003)
Select one or more cells in the Excel worksheet.
Select Edit | Copy or press Ctrl+C to copy them to the clipboard.
Switch to your Word document.
Click where you want the Excel information to appear.
Select Edit | Paste Special...
Click the "Paste Link" radio button.
You can select from several formatting options. If you want the text to look as in Excel, select HTML or Formatted Text; if you want the text to take on the formatting of the Word document, select Plain Text.
Repeat the above steps as needed.