Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2015
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word 2010 Merge from Excel into Table Directory

    I have been struggling with this for awhile...

    I have an Excel 2010 file that contains a database of various trademark data.

    I want to end up with a Word document (Table) that contains one row of data for each trademark but lists all of the upcoming actions due for each trademark. Each row of data will change with our internal file number.

    I have reviewed the Catalogue Mailmerge Turorial (thank you for sharing!!) and have been semi-successful - but not successful in getting the data to merge in a table format.

    I've attached the latest form Word document showing the code I have created and a sample of the desired resulting report format. Also attached is a data excel file -- the excel file contains only a small sample of the records needed for the merge.

    I appreciate any help I can get!!

    Teresa
    Attached Files Attached Files

  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
    You can't use the directory merge approach to generate a table column with multiple entries - each entry must be a new row. For that, you can use something like the attached.
    Attached Files Attached Files
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    New Lounger
    Join Date
    Jan 2015
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm so bummed. From review of the formats shown in the tutorial, I was hoping my desired report format could be done.

    Now I am thinking an Excel pivot table may be the answer. I will give that a try.

    Thanks again for your assistance!

    Teresa

Posting Permissions

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