#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
I've never worked with Word tables before. I'll go try to figure those out!
|
Tags |
mail merge, text box, two docs per sheet |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Inputing Text from Excel sheet to multiple Word documents and Visio File | Jazz43 | Office | 1 | 05-30-2013 02:08 PM |
Mail Merge with Booklets is Merging all documents into One stapled Booklet | 15Degrees | Mail Merge | 1 | 01-31-2013 02:06 AM |
Mail merge and password protected documents | sheep_go_baa | Mail Merge | 1 | 01-17-2012 03:31 PM |