Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Yreka, California, USA
    Posts
    192
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I'm trying to do a merge in Word 2007 to a table cell and upon merge I would like to have another row created until all entries have been merged into a directory that is in a table format. The merged data fields are all in column A of the table. In WordPerfect it is done with <next row> but in Word 2007 I can't locate a similar code. Next Record doesn't work, because I might have four rows or I might have ten. And I don't want to have all the rows of the table already constructed. Only the rows that are needed like WordPerfect des with Next Row. Hopefully someone has accomplished this! If WordPerfect can do it Word should, right? I checked out the archives, but could find nothing wuite like this. Thanks much,
    Thanks much, Judy Crawford

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    In step 1 of the Mail Merge wizard/task pane, select Directory as mail merge type. This is the essential step.
    Then create a table with a single row in the document, and insert the merge fields and other text into the table as needed.
    Don't put anything below the table.
    You'll see only a single row while you're working with the merge document, even when you're previewing the data.
    But when you merge to a new document (or directly to the printer), Word will create a new row for each record from the data source.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Yreka, California, USA
    Posts
    192
    Thanks
    2
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='799242' date='21-Oct-2009 12:53']In step 1 of the Mail Merge wizard/task pane, select Directory as mail merge type. This is the essential step.
    Then create a table with a single row in the document, and insert the merge fields and other text into the table as needed.
    Don't put anything below the table.
    You'll see only a single row while you're working with the merge document, even when you're previewing the data.
    But when you merge to a new document (or directly to the printer), Word will create a new row for each record from the data source.[/quote]

    Ok, Hans, I see that works, but in my scenerio it is a Personnel Elgibility List that has information at the top and again at the bottom, as well as a header row. How will this work? I've attached my file and a fake data spreadsheet just so you'll get the picture of what I need. Thanks,
    Attached Files Attached Files
    Thanks much, Judy Crawford

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I assume that you want to group the data by Position, i.e. one letter for Zoo Keeper, another for Wine Taster, etc.
    That is very well possible, but it's not trivial
    .
    Our moderator and Word MVP macropod has written a tutorial about that kind of mailmerge: Word 97-2007 Mailmerge Tutorial: Create Sorted Listings (v1.52).
    It comes with a sample document and spreadsheet. Please read the tutorial carefully.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Yreka, California, USA
    Posts
    192
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hans, I got it to sort of work using <Next Record>, but the rows have to be pre populated. The position code needs to be taken out, but it wasn't in in WordPerfect either. I'm teaching a class on Mail Merge in the morning and have people from the HR departmetn in the class and really wanted to show them that Word could do what WordPerfect can. So, with this example I'bve attached it's a duplication except for the finite number of rows on the Eligibility List. I will take time to go through the tutorial, but maybe not this afternoon. Appreciate the help.
    Attached Files Attached Files
    Thanks much, Judy Crawford

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Macropod's (admittedly complicated) field codes are the best solution, but if you're in a hurry, here is a rather simplistic workaround:

    1. Create a merge document of type Directory with only a single-row table, with the merge fields in the first cell.
    2. Perform the mail merge. This will result in a document with one row per record, but without any text above or below the table.
    3. From your original merge document, remove all rows with merge fields from the table. Only the text above the table, the header row and the text below the table remain.
    4. Copy the contents of the merged document from step 2, and paste it into the document from step 3 below the header row.

Posting Permissions

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