i have a file of ms word having 3 pages of mail merge the data from an excel file (sheet1).when i type a very big name in excel sheet and execute mail merge ,the mail merge results shows that some of the bottom lines of page 1 of ms word goes to page no 2 and so on .i want to stop that .the total data and text in one page not expand to next page even if i write very very big name or data in excel sheet from where the mail merge pickup the data.is there any vba code or other solution?



other post link http://www.excelforum.com/excel-new-...xcelsheet.html

Cross post without links http://www.excelforum.com/excel-new-...xcelsheet.html

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

If you want to control the amount of space a mergefield's data can occupy, put the mergefield into a table cell with a fixed row height and cell width.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]