Daniele Brunengo
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.
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.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And where do you want to run it from, a word document or the excel file ... or somewhere else even?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
cheers, teylyn
ASKER
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
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.
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.
ASKER
Yes, I know how to split, I was asking for suggestions on equity. I'll do what I think is right, then.
ASKER
Problem solved.
Thanks, Maioneis (love the handle. Do you serve fries with that? :-)) )
ASKER
It's a merge between the english word and the italian word (maionese), since I'm from Italy. :-)
Please also indicate if word files are to left open, saved, conventions etc.
Chris