Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2013
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert table row on a non blank record.

    The database program I am using can merge directly to a word document from an export that mimics a flat database file. Each row will have a unique identifier and then from 1 to 12 data fields filed out. for example the header would look something like this.

    PRIMARY_KEY, ITEM_A_1, ITEM_A_2,...., ITEM_A_12, ITEM_B_1,... ,ITEM_B_12

    If there are only 4 ITEM_X_X fields filled out then 5-12 will be blank. I want the final output for each record to look something like this.

    PRIMARY_KEY
    ITEM_A_1 | ITEM_B_1
    ITEM_A_2 | ITEM_B_2
    ....

    PRIMARY_KEY will just appear at the top of each merge record. Each ITEM_A_X and ITEM_B_X needs to be in it's own row of a table that will also contain 30 blank columns. The problem is each page can only hold 4 table rows. If rows 5-12 are blank I don't want two pages of blank table rows to show up. Is there anyway to insert a table row only if the value isn't blank? I'd also like to add the table header in a row at the top of each page but I think I know how to do that if I can get the other part to work.

    Hope that all makes sense. I'm using Office 2010 but some of the people who will need to use this may be on the latest version soon.

    Thanks in advance.

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    See: http://windowssecrets.com/forums/sho...merge-Tutorial - it's a Sticky thread at the top of this forum!
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •