Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2010
    Location
    Houston, Texas, USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have data in an Access 2003 query that I want to use to populate a table in a Word 2003 document.

    The table is very simple, with 3 columns: Category, Name and Percent (please forgive this demo - I haven't learned your tables feature as yet):

    Category | Name | Percent
    <<Ctgy>> | <<Name>> | <<Pct>>


    What I want is for the merge to generate a new row for each new record as it is merged so that the merge output looks like this:

    Category | Name | Percent
    Grapes | Concord | 12.5%
    Apples | Gala | 35.9%
    Oranges | Valencia | 22.5%


    I have used <NextRecord> at the end of the first row (which didn't work) and at the beginning of a second row to no avail. Does you guys know if what I want to do can be done in Word? And, if so, will you please instruct me as to how? Or, if not, is there an alternative?

    Thank you so much!!

    C. Homer

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi C. Homer,

    Welcome to the Lounge.

    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. Do read the tutorial before trying to use the mailmerge document included with it.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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