#1
|
|||
|
|||
Creating a table for a variable number of rows
Hi
Please can someone help. I'm attempting to create a mail merge document which has two tables. My data is coming from an excel worksheet. Both tables need to have a certain number of rows for the user to fill in (by hand!!). The number of rows in each table is driven by a column in the worksheet. I have already setup the table headings. I've played around with If statements but I'm nore sure how how to use an if statement to add rows to a specific table. Any help would really be appricated. Thank you |
#2
|
||||
|
||||
You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...ngs-(2000-2010) or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it. For some worked examples, see the attachment to the posts at: https://www.msofficeforums.com/mail-...html#post23345 https://www.msofficeforums.com/mail-...html#post30327 Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from: Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or Doug Robbins at https://skydrive.live.com/?cid=5aedc...615E886B%21566
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge to create specific number of table rows | flackend | Mail Merge | 4 | 12-01-2023 02:49 PM |
Using macro to add variable number of rows to a protected word table | Julia | Word Tables | 1 | 01-09-2013 06:04 AM |
Moving data from multiple rows to 1 row for each program number | ballj_35 | Excel | 3 | 08-01-2012 05:10 AM |
merging rows and creating sub-rows | gib65 | Excel | 2 | 12-09-2011 02:09 PM |
Fixing number or rows in a table | burnsie | Word | 2 | 07-12-2011 02:59 AM |