#1
|
|||
|
|||
mail merge from excel sheet
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 |
#2
|
||||
|
||||
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 |
#3
|
||||
|
||||
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] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merging Word by excel sheet | Marcovalkenburg | Mail Merge | 3 | 06-05-2015 05:40 PM |
Mail merge, text boxes, and two documents per sheet! | MelissaAnnie | Mail Merge | 2 | 09-24-2014 03:46 PM |
Can't merge mail from Excel | Mahmed1 | Mail Merge | 23 | 04-06-2014 07:23 AM |
Merge from Excel sheet into Word Incomplete | gsandle | Office | 0 | 07-16-2013 11:51 AM |
How to Copy data from Outlook mail and Paste it in a Excel sheet? | padhu1989 | Outlook | 0 | 09-11-2012 04:07 AM |