 |
 | 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 / April 2005Format a label using the split cell approach for two different tex
I'm using mail merge to make labels that require two different text directions. I have successfully learned the split cell technique which solves my vertical (number) problem (Thanks Graham!); however my horizontal text is not fixed text. It needs to match up with its corresponding vertical number. Is it possible to do two mail merges in this format? I would really like to avoid cutting and pasting. Provided you set the numbers with SEQ fields or have your mergeable data in the same data file as the mergeable numbers (i.e. you can only merge from a single data file) then simply insert your merge fields in place of the fixed data in the split cell. Just make sure you have only the correct number of NEXT record fields.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I'm using mail merge to make labels that require two different text > directions. I have successfully learned the split cell technique > which solves my vertical (number) problem (Thanks Graham!); however > my horizontal text is not fixed text. It needs to match up with its > corresponding vertical number. Is it possible to do two mail merges > in this format? I would really like to avoid cutting and pasting. I am merging data that is in the same file. My trouble comes when I try to to insert the new fields (in place of the fixed data) in the second part of the split cell. If I click on udate the label or replicate, I loose these fields as these are replaced by the vertical data and I am back to square one. I must be missing a critical step. Any suggestions? > Provided you set the numbers with SEQ fields or have your mergeable data in > the same data file as the mergeable numbers (i.e. you can only merge from a [quoted text clipped - 8 lines] > > corresponding vertical number. Is it possible to do two mail merges > > in this format? I would really like to avoid cutting and pasting. If you use split cells and the replicate function, it will conspire against you - as you have discovered. You will need to manually copy and paste the cell content into the required cells. It's a bit more trouble than Word's propagation (and it would probably be helpful if you told the merge process that this was a form letter merge document type rather than a label merge, so that it will not try to pre-empt your requirements), but you only have to do it once. You will still need a NEXT record field in every *label* except the first (but not in every cell). Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I am merging data that is in the same file. My trouble comes when I > try to to insert the new fields (in place of the fixed data) in the [quoted text clipped - 23 lines] >>> corresponding vertical number. Is it possible to do two mail merges >>> in this format? I would really like to avoid cutting and pasting. I told the merge process it was a form letter and chose to open an existing document (my split cell label with the vertical text that I have saved). I am really not sure if this is what you had in mine. I inserted my fields into the second cell and it did work but only for that particular cell. How do I get word to put a NEXT record field where I need it to go? Thanks for your help. > If you use split cells and the replicate function, it will conspire against > you - as you have discovered. You will need to manually copy and paste the [quoted text clipped - 32 lines] > >>> corresponding vertical number. Is it possible to do two mail merges > >>> in this format? I would really like to avoid cutting and pasting. This is difficult to explain :) Each finished label comprises two cells, thanks to the splitting. This is completely at odds with what a label merge expects to find so we are working around that. One cell is rotated and contains your numbering. The other cell will contain your other fields, but the two cells together are treated as if they were one. In all but the first label, one of those cells must contain a NEXT field so that the information from the following record will be inserted in that cell. From the merge toolbar (http://www.gmayor.com/mail_merge_labels_with_word_xp.htm ) insert the fields you require in the second cell of the first label. Insert a next field (from the toolbar) at the beginning of the cell. Copy the cell contents to the clipboard and paste into the second cell of every label on the page. Finally DELETE the NEXT field from the FIRST label. If the rotated cell with the numbering is to the LEFT of fixed cell, put the NEXT fields in the rotated cells rather than in the fixed cells (NOT IN BOTH!!!) or the numbering could be out of sequence with the associated records. Does that help? If not come back and we'll try again ;) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I told the merge process it was a form letter and chose to open an > existing document (my split cell label with the vertical text that I [quoted text clipped - 49 lines] >>>>> possible to do two mail merges in this format? I would really >>>>> like to avoid cutting and pasting. Thanks Graham. Success!! My next question: is it possible to save this format as a template and just change recipient files when I need to make more labels? BK > This is difficult to explain :) > [quoted text clipped - 75 lines] > >>>>> possible to do two mail merges in this format? I would really > >>>>> like to avoid cutting and pasting. Certainly - just attach the appropriate data file from the mailmerge toolbar - though it will have to employ the same field names for it to work. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thanks Graham. Success!! My next question: is it possible to save > this format as a template and just change recipient files when I need [quoted text clipped - 91 lines] >>>>>>> possible to do two mail merges in this format? I would really >>>>>>> like to avoid cutting and pasting. |
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.