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

    Arrow Mailmerge to Table

    Hi,
    I'm trying to create a statement mail merge that would put data into table and it's not working out for me. Can you please help?
    I am including the mail merge template, the excel file data, the result (which is not working out), and two sample of how the output should look like.

    Thanks alot!
    NP
    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
    Please don't hijack other peoples' threads. I've moved your post to a new thread.

    As for your attachment, I see no evidence of any mergefields. 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 in the 'Sticky' post at the top of this forum:
    http://windowssecrets.com/forums/sho...merge-Tutorial
    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 attachments to the posts at:
    http://www.msofficeforums.com/mail-m...html#post23345
    http://www.msofficeforums.com/mail-m...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

    In addition to a 'Many to One' merge, the latter handles:
    • Merge with Charts
    • Duplex Merge
    • Merge with FormFields
    • Merge with Attachments
    • Merge to Individual Documents
    • Merge, Print and Staple
    Last edited by macropod; 2013-11-13 at 17:06.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    New Lounger
    Join Date
    Nov 2013
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sorry for hijacking other people's threads. This is my first time posting anything in the forum. I did have mergefields in my merge template but however the results did not put the data into tables for me (see the snapshots). I want the Name and address to go into the top tox and award date, performance period, and amount to go into the bottom box(es). I don't know what I did wrong.

    Thanks.
    Attached Files Attached Files

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Your latest attachment has a picture of some mergefields before the table, but no apparent attempt to incorporate the table into the field codes as described in the tutorial. And, since your tables have a header and a row for totals, you can't use the field codes you have there. Rather, you'd need to use the field coding from the tutorial's 'Calculating Group and Sub-Group Totals' example (page 12) as the basis for your own. Alternatively, you could use the approach outlined in the 'Calculating Table Totals' example (page 18) as the basis for your merge. Note that the latter requires the running of a macro as well.
    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
  •