Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-21-2011, 11:34 AM
flackend flackend is offline Mail Merge to create specific number of table rows Windows XP Mail Merge to create specific number of table rows Office 2003
Novice
Mail Merge to create specific number of table rows
 
Join Date: Aug 2011
Posts: 6
flackend is on a distinguished road
Lightbulb Mail Merge to create specific number of table rows

I have a sign-up sheet that pulls information about the event (name, location, time, number of seats, etc) with mail merge.



I'd like the sign-up sheet to layout a specific number of rows in a table for attendees' information based on the event location's number of seats available.


So I'm thinks something like this (in english):

Code:
if merge data 'location' equals 'Hall A' then create 28 rows
or

Code:
create {merge data, 'num_of_seats'} rows
If that makes sense...

Thanks for any help!
Reply With Quote
  #2  
Old 08-22-2011, 04:19 AM
macropod's Avatar
macropod macropod is offline Mail Merge to create specific number of table rows Windows 7 64bit Mail Merge to create specific number of table rows 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

Hi flackend,

For this, you could create whatever conditional tables you might need and embed each if them in an IF field, coded along the lines of:
{IF{MERGEFIELD location}= "Hall A" "Table for Hall A"}
{IF{MERGEFIELD location}= "Hall B" "Table for Hall B"}
etc

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 08-24-2011, 11:49 AM
flackend flackend is offline Mail Merge to create specific number of table rows Windows XP Mail Merge to create specific number of table rows Office 2003
Novice
Mail Merge to create specific number of table rows
 
Join Date: Aug 2011
Posts: 6
flackend is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Hi flackend,

For this, you could create whatever conditional tables you might need and embed each if them in an IF field, coded along the lines of:
{IF{MERGEFIELD location}= "Hall A" "Table for Hall A"}
{IF{MERGEFIELD location}= "Hall B" "Table for Hall B"}
etc

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.
It worked great, thanks! I didn't think realize you could insert a table in an IF statement like that!
Reply With Quote
  #4  
Old 11-30-2023, 11:21 PM
mmurali mmurali is offline Mail Merge to create specific number of table rows Windows 10 Mail Merge to create specific number of table rows Office 2016
Novice
 
Join Date: Nov 2023
Posts: 1
mmurali is on a distinguished road
Default

How to set fixed number of rows in a page in ms word mail merge. eg. 15 rows table in a page while merging
Reply With Quote
  #5  
Old 12-01-2023, 02:49 PM
Guessed's Avatar
Guessed Guessed is offline Mail Merge to create specific number of table rows Windows 10 Mail Merge to create specific number of table rows Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Are you saying this merge is one record per row or are there multiple columns also containing records?

Would you not just set a table row height that allows 15 rows?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Tags
mail merge, mailmerge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge to create specific number of table rows Mail Merge, Number to 2 Decimal Places Vampy99 Mail Merge 7 09-25-2011 05:41 AM
Mail Merge to create specific number of table rows Fixing number or rows in a table burnsie Word 2 07-12-2011 02:59 AM
Mail Merge to create specific number of table rows Mail merge number fields outputting inconsistently rekcots Mail Merge 2 05-18-2011 06:32 AM
Create Hyperlinks from Word to specific location in PDF sukanyae Word 0 02-25-2010 04:08 PM
Insert formatted table into word (mail merge) manojbmsce Mail Merge 0 09-25-2008 02:25 AM

Other Forums: Access Forums

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


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