Merging excel data into word

[MrPlow]

Ok, I have a feeling this process is quite simple, but I haven't bee
able to figure it out on my own, nor find anything in FAQ's.

I have created an excel spreadsheet containing the following:
students' last name, first name, ID number, advisor and counselo
(obvioulsy Im in education)

I would now like to create a phone call log for each student, but woul
like to import each students' info into this word document. So as
print the 100 or so pages, page one would have the first students info
page two would contain the second students info, and so on.

Any help is greatly apprectiate, thanks in advance

 

[JE McGimpsey]

Take a look here:

http://word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm

especially the section on "Using Excel as a Data Source"

 

[MrPlow]

Ah wonderful, thanks for pointing me in the right direction.

One more question now that deals with formatting.

On line one I have the name and ID number. What is the best way to
make sure that the ID data always begins on the same column regardless
of how long the students name is?

Thanks again!