| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I merge multiple rows into one letter?
I have a excel file with student names, status, highschool name. I want to
merge it into a word document (memo) that is directed to the highschool. There are several names and status' to each highschool. For example: there may be four names and status' with one highschool. How do I get the highschool name to show up once at the top of the memo and then the list of multiple names and status' in the body of the memo. -- Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I merge multiple rows into one letter?
I believe you can only do this by having all your names/status in a single
row as MM processes a row (record) per document: e.g Column headings would be: School, Name1,Status1,Name2,Status2, etc HTH "Jill" wrote: I have a excel file with student names, status, highschool name. I want to merge it into a word document (memo) that is directed to the highschool. There are several names and status' to each highschool. For example: there may be four names and status' with one highschool. How do I get the highschool name to show up once at the top of the memo and then the list of multiple names and status' in the body of the memo. -- Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merge data into form letter | Excel Discussion (Misc queries) | |||
| How to merge multiple rows of data to new formated sheets | Excel Discussion (Misc queries) | |||
| Linking Multiple Rows to Use in Mail Merge | Excel Discussion (Misc queries) | |||
| how do I merge labels onto a seperate form letter ? | Excel Discussion (Misc queries) | |||
| in mail merge can you add something in to the body of the letter | Excel Discussion (Misc queries) | |||
Linear Mode
