Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-24-2014, 02:53 PM
MelissaAnnie MelissaAnnie is offline Mail merge, text boxes, and two documents per sheet! Windows 7 32bit Mail merge, text boxes, and two documents per sheet! Office 2010 32bit
Novice
Mail merge, text boxes, and two documents per sheet!
 
Join Date: Sep 2014
Posts: 2
MelissaAnnie is on a distinguished road
Default Mail merge, text boxes, and two documents per sheet!

I got moved to a department at work (Finance) where things have been done in a very clunky way for 20 years, and I'm being expected to make changes to become effective and efficient.
I want us to begin printing our cheques, instead of writing them by hand, since we average 600-800 cheques per month. A staff member "helped me out" by creating a Word document that I want to use as a mail merge to print my cheques. His placement is spot on, but unfortunately he used text boxes to create this template. My first question: Is there a way I can remove these text boxes while keeping the placement of the text they are holding? I suspect not... :-( Given that assumption, is there a way I can use this template with mail merge fields in the appropriate boxes?


Next, our cheques are 2 per page, but I can't seem to get the second one on the page to be different than the first one on the page. I can't figure out how to add a "Next Record" field so the merge will pull the next item from the data source. When I've completed my merge for a test run, it gave me 5 pages with each page containing two of the same records. My test data source has 10 records.
Any help would be greatly appreciated!
Reply With Quote
  #2  
Old 09-24-2014, 03:37 PM
macropod's Avatar
macropod macropod is offline Mail merge, text boxes, and two documents per sheet! Windows 7 64bit Mail merge, text boxes, and two documents per 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

I think you'll need to start over, using a Word table instead of the textboxes. If you create a table with a cell structure arranged so there are cells overlaying the positions where you need the output to go, then insert the mergefields into those cells, you'll then have two options:
1. Use the document as is for a directory merge (you may need to adjust the size of the empty paragraph that follows the table cell to get the alignment right for the 2nd record on each page; or
2. Copy the table and paste the copy below it. This will allow you to use a letter or label merge. You'll need to add a «NextRecord» field between the last mergefield on the first portion and the first mergefield on the second portion.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-24-2014, 03:46 PM
MelissaAnnie MelissaAnnie is offline Mail merge, text boxes, and two documents per sheet! Windows 7 32bit Mail merge, text boxes, and two documents per sheet! Office 2010 32bit
Novice
Mail merge, text boxes, and two documents per sheet!
 
Join Date: Sep 2014
Posts: 2
MelissaAnnie is on a distinguished road
Default

I've never worked with Word tables before. I'll go try to figure those out!
Reply With Quote
Reply

Tags
mail merge, text box, two docs per sheet

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge, text boxes, and two documents per sheet! Deleting text boxes from multiple documents OskarSK Word VBA 2 09-10-2014 02:38 AM
Creating new documents from a mail merge template pnjcarter Mail Merge 1 02-03-2014 06:42 PM
Mail merge, text boxes, and two documents per sheet! Inputing Text from Excel sheet to multiple Word documents and Visio File Jazz43 Office 1 05-30-2013 02:08 PM
Mail merge, text boxes, and two documents per sheet! Mail Merge with Booklets is Merging all documents into One stapled Booklet 15Degrees Mail Merge 1 01-31-2013 02:06 AM
Mail merge, text boxes, and two documents per sheet! Mail merge and password protected documents sheep_go_baa Mail Merge 1 01-17-2012 03:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:57 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