Importing Excel info into Word
Posted by Katie Theriault on July 13, 2001 11:28 AM
I am wondering if it is possible to import info from Excel into Microsoft Word; specifically, take info from Excel and import it to print labels in Word. I really don't want to resort to typing each piece of info into the Word boxes for labels. All I can think of is cut and paste, what can turn out to be an all day task. Or, even better, is there a way to do it in Excel without literally measuring?
Thank you for any help.
Posted by Ben O. on July 13, 2001 12:23 PM
Use Word's Mail Merge feature. Select Toos > Mail Merge in Word. On Step One choose labels. On Step 2, set up your Excel spreadsheet as your data source. When you edit your labels, you can insert the column headers from your Excel spreadsheet as Merge Fields. Then you can merge it right to the printer or to a document.
-Ben O.
