Reply
 
Thread Tools Display Modes
  #1   Report Post  
dredmond17 dredmond17 is offline
Junior Member
 
Posts: 1
Default Can I mail merge each record into multiple rows with 3 records per page?

I'm trying to mail merge data from Excel into a Word document that is laid out as a table with 3 columns and 12 rows (i.e., 36 cells total in the Word document). The spacing needs to be precise because the page is then die cut with a metal plate of a fixed shape. The challenge is that each record in Excel has 12 fields, which I want to populate vertically in each column - one field's data per row going down the page. Then I want the next record to start at the top of the next column with the 12 fields of data arranged vertically down the second column. Then again for the 3rd column in the Word document. This would be easy if I just had 3 columns and 1 row, but I need each field of each record in its own table cell so that data of varying lengths doesn't mess up the vertical spacing for fields lower down the page.

The problem is that Word reads the Next Record tag at the top of the 2nd and 3rd columns before returning the remaining 11 fields of data for the first record. It's reading my table cells left to right instead of top to bottom in each column. Is there a way to do this? Perhaps with text boxes instead of table rows? Any help or pointers to more information would be much appreciated as I can't seem to find anyone else with this same issue.
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help With Form Ltr Mail Merge With Multiple Input Records Per Page Sheila Mailmerge 2 September 11th 09 10:48 PM
Multiple records mail merge - Another Question mom2dramaqeen Mailmerge 10 April 4th 09 12:36 AM
Mail Merge Multiple Records Peter Hibbs[_2_] Mailmerge 5 February 16th 09 05:43 PM
Multiple Records Mail Merge yuckster Microsoft Word Help 1 November 26th 05 08:08 AM
Mail Merge - Multiple Address Records paldba Mailmerge 1 August 1st 05 07:41 PM


All times are GMT +1. The time now is 08:03 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"