ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I merge multiple rows into one letter? (https://www.excelbanter.com/excel-discussion-misc-queries/144655-how-do-i-merge-multiple-rows-into-one-letter.html)

Jill

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

Toppers

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



All times are GMT +1. The time now is 11:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com