Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merging excel data into word
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 apprectiate, thanks in advance. -- MrPlow ------------------------------------------------------------------------ MrPlow's Profile: http://www.excelforum.com/member.php...o&userid=27076 View this thread: http://www.excelforum.com/showthread...hreadid=465947 |
#2
|
|||
|
|||
Take a look he
http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm especially the section on "Using Excel as a Data Source" In article , MrPlow 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 |
#3
|
|||
|
|||
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! -- MrPlow ------------------------------------------------------------------------ MrPlow's Profile: http://www.excelforum.com/member.php...o&userid=27076 View this thread: http://www.excelforum.com/showthread...hreadid=465947 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exporting excel worksheet to word | Links and Linking in Excel | |||
Data Automation from Excel to Word | Excel Discussion (Misc queries) | |||
combined cell data from Excel to Word (2003) | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Word field codes in Excel data file Includetext | Excel Discussion (Misc queries) |