Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2015, 12:40 AM
mahesh kumar gupta mahesh kumar gupta is offline mail merge from excel sheet Windows 7 32bit mail merge from excel sheet Office 2007
Novice
mail merge from excel sheet
 
Join Date: Aug 2015
Posts: 2
mahesh kumar gupta is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-09-2015, 01:52 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline mail merge from excel sheet Windows 7 64bit mail merge from excel sheet Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 08-09-2015, 03:10 AM
macropod's Avatar
macropod macropod is online now mail merge from excel sheet Windows 7 64bit mail merge from excel sheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge from excel sheet 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
mail merge from excel sheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft