 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2004Merge Word doc w/specific rows of Excel spreadsheet
Hello - I'm trying to merge a Word letter with an Excel spreadsheet that has 1038 rows -- However, I only want the letter merged with every 3rd row (rows 2, 5, 8, 11, etc.). How do I accomplish this? Marcia H. Hi MarciaH, > I'm trying to merge a Word letter with an Excel > spreadsheet that has 1038 rows -- However, I only want > the letter merged with every 3rd row Is there any common factor that identifies these rows, other than "every third"? If not, your best bet might be with a catalog merge type that has "Next Record" inserted at the very beginning and very end of the letter (with a Page Break just before that last one). Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) >-----Original Message----- >Hi MarciaH, [quoted text clipped - 23 lines] >. >The only common factor -- well really isn't -- but the last column is a counter.. i.e. the first row /last column would contain the "word" 1000, next row, last column would contain 1001.etc. Marcia Hi Marciah, > The only common factor -- well really isn't -- but the > last column is a counter.. i.e. the first row /last > column would contain the "word" 1000, next row, last > column would contain 1001.etc. I can't think of any way that can be used to filter the records. I take it there's no way in Excel that you could filter them, either, to see only those you want to merge? If not, then you'd need to do something along the lines I suggested in my last reply. For example, if you want to merge rows 3, 6, 9, etc. insert two "Next Record" fields at the very start of the main merge document. (From the "Insert Word Field" button on the mail merge toolbar) Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.