Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Let's say we have the staff list stored as an Excel spreadsheet file and we need to generate the document in formal formation or any other style to display those data using Word document.

How can we do that?

share|improve this question
up vote 2 down vote accepted

Easiest to do with a Mail Merge (even though you probably aren't mailing) It just will create the correct fields.

Highlight the "range" that you want to use in word in the excel document and name it.

Save and close your workbook.

Open the word document that you want to insert the names into.

Choose mailings from the menu bar and then "select recipients" button and then "use existing list" Browse to the excel sheet you saved earlier and select it and click "open" choose the range that you selected earlier.

Click on the "insert merge field" button to choose the column header for the information that you want displayed on the page. it will insert <<column head name>> into the word document (this will later get filled with the names that you want.)

To get a a preview of the end result, click on "finish and merge" button and choose "edit individual documents" and then the "ALL" radio button and you will see how word inserts the person's name where you want it.

share|improve this answer
@G Koe So lovely. I got it working! Thanks a ton! – Nam G VU Mar 6 '12 at 11:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .