Link to home
Start Free TrialLog in
Avatar of Daniele Brunengo
Daniele BrunengoFlag for Italy

asked on

Is it possible to have Word read data from an Excel document?

Hello, I have to create multiple copies of a file for my school. The file is created with Word 2003 and contains surname, name and password for each of the students. This means I'd have to create hundreds of files.

Since I have surname, name and password in an Excel file, is it possible to have Word automate this, maybe with fields or something else? So that Word automatically creates the files, or at least reads the data from the Excel file.
I have zero experience with Word macros and scripting, mind you.
Avatar of Chris Bottomley
Chris Bottomley
Flag of United Kingdom of Great Britain and Northern Ireland image

It's doable, can you suplly a sample excel file layout, (no real data a few dummy entries only) and a sample of how the dummy data should appear in word as well.

Please also indicate if word files are to left open, saved, conventions etc.

Chris
Avatar of Daniele Brunengo

ASKER

The word files can be saved, I need to save them to a cd afterwards.

The files are very simple.

The doc file has some text and then the following list:

Surname:
Name:
Password:

where the data from the excel file should go.

The excel file has 4 columns, ID (a progressive number), surname, name and password.
SOLUTION
Avatar of ManicD
ManicD
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
And where do you want to run it from, a word document or the excel file ... or somewhere else even?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I can run it from the word document, but it really makes no difference as long as it works. This mail merge option is good, I don't need to create a different document for each name, a different page for each would be fine. Individual printed documents is a no-go, since I'm working on this at home but I need to print it at work.
So, fire up the Mail Merge Wizard in Word, when you need to select a data source, navigate to the Excel file where your names/passwords are saved. In the final merge step select "Edit individual documents", which will create one document with a new page for each person.

cheers, teylyn
Done, it worked great! Quite easy! Thanks a lot. Now how should I deliver points? ManicD suggested mail merge, but your instructions were enough to go through with it without having to use his links.
That's totally up to you. You can acknowledge several answers by splitting the points.

cheers, teylyn
Split points - Up to you how you proportion the split

FAQ: https://www.experts-exchange.com/help.jsp#hs=8&hi=100 
Can I split the points?

You split the points. Each comment box has a button that says Accept Multiple Solutions. Click that, and you will see a page that allows you to assign points to any of the comments in the thread. There is a grade box at the bottom of the page.

Note: The total of the point splits must equal the original amount you assigned to the question, and no comment can receive fewer than 20 points. The Comment that was posted first is the Accepted Solution, and the rest of the comments are Assisted Solutions.
Yes, I know how to split, I was asking for suggestions on equity. I'll do what I think is right, then.
Problem solved.
Thanks, Maioneis (love the handle. Do you serve fries with that? :-)) )
It's a merge between the english word and the italian word (maionese), since I'm from Italy. :-)