Merging excel data into word

[MrPlow]

Ok, I have a feeling this process is quite simple, but I haven't been 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 counselor (obvioulsy Im in education)

I would now like to create a phone call log for each student, but would like to import each students' info into this word document. So as I 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 apprectiated, thanks in advance.

[JE McGimpsey]

Take a look here:

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

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



In article <[email protected]>,
MrPlow <[email protected]> wrote:

> Ok, I have a feeling this process is quite simple, but I haven't beenable 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 counselor(obvioulsy Im in education)
>
> I would now like to create a phone call log for each student, but wouldlike
> to import each students' info into this word document. So as Iprint 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.--
> MrPlow------------------------------------------------------------------------
> MrPlow's Profile:
> http://www.excelforum.com/member.php...erid=27076View this
> thread: http://www.excelforum.com/showthread...hreadid=465947

[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!