Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-30-2016, 12:53 AM
Marco Marco is offline long table from mail merge: split + arrange position of splitted parts Windows Vista long table from mail merge: split + arrange position of splitted parts Office 2007
Novice
long table from mail merge: split + arrange position of splitted parts
 
Join Date: Apr 2015
Posts: 15
Marco is on a distinguished road
Default long table from mail merge: split + arrange position of splitted parts

Dear all, can anybody help with the following issue?

I have a mail merge function that takes data from an Access file and put them in a 2-column table.
This table has several tens (up to some hundreds) of lines, but is very narrow (maximum width not exceeding 20 mm).


I would like to:

1) automatically split the table at the end of each page, avoiding splitting of cells, which I suppose should be easy.

2) automatically arrange horizontally the chunks of the original table so that they will use all the space of each page. That is: each of my A4 pages should contain up to 5 pieces of the original table arranged each aside the other (with an empty space between them).
The results should be similar that I would have writing a plaint text in a word document with columns.
Cells are meant to be printed and cut out as labels.

Thanks for any suggestion
Reply With Quote
  #2  
Old 03-30-2016, 01:18 AM
macropod's Avatar
macropod macropod is online now long table from mail merge: split + arrange position of splitted parts Windows 7 64bit long table from mail merge: split + arrange position of splitted parts Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,726
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Is there a reason you can't just give the mailmerge main document a multi-column page layout?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-30-2016, 02:55 AM
Marco Marco is offline long table from mail merge: split + arrange position of splitted parts Windows Vista long table from mail merge: split + arrange position of splitted parts Office 2007
Novice
long table from mail merge: split + arrange position of splitted parts
 
Join Date: Apr 2015
Posts: 15
Marco is on a distinguished road
Default

Actually there isn't, but it is not going to work.

In the same way, the table I get from mail merge doesn't split automatically respecting pages, as usually happens when you normally add rows to a table in a ordinary word document.
Also, the original table is not going to respect page margins.
When the table is too high (too many rows) for the page, the upper border of the table shift up until it aligns perfectly (no spacing) with the edge of the page. At the bottom of the page, tens of exceeding rows will "disappear" out of my page, until some of them will appear in a second page, with alignment as in the first page and several rows not visible between page 1 and 2.

See attachment
Attached Files
File Type: docx test page.docx (14.4 KB, 5 views)
Reply With Quote
  #4  
Old 03-30-2016, 04:20 AM
macropod's Avatar
macropod macropod is online now long table from mail merge: split + arrange position of splitted parts Windows 7 64bit long table from mail merge: split + arrange position of splitted parts Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,726
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

The only reason it doesn't work properly with your attachment is that you've set the table's wrap format to 'around'.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 03-30-2016, 05:15 AM
Marco Marco is offline long table from mail merge: split + arrange position of splitted parts Windows Vista long table from mail merge: split + arrange position of splitted parts Office 2007
Novice
long table from mail merge: split + arrange position of splitted parts
 
Join Date: Apr 2015
Posts: 15
Marco is on a distinguished road
Default

OUCH!



Thanks a lot
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
long table from mail merge: split + arrange position of splitted parts Mail merge issues not covered in long post idzineit Mail Merge 4 03-14-2016 10:23 AM
Help Please: New VBA user trying to use a macro to split Mail Merge documents. Two Run-Time Error zipit189 Word VBA 7 03-18-2015 01:13 PM
long table from mail merge: split + arrange position of splitted parts Split each page of mail merge into separate pdf Declan Mail Merge 1 05-28-2014 02:02 AM
long table from mail merge: split + arrange position of splitted parts Split multi-page mail merge document, then name file from letter info. BriMan83 Mail Merge 1 04-24-2013 11:35 PM
long table from mail merge: split + arrange position of splitted parts Automatically split Mail Merge based on number of pages SaneMan Mail Merge 1 12-03-2011 01:11 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:59 PM.


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