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

    Mail Merge Directory issue in Word 2013

    Dear all,

    I kindly ask if someone can help me.

    I have data in excel (5 rows 3 columns) and I want to make word letter which will have some text and the beginning and then table merged from excel and then text again. My problem is that I am getting 5 letters/pages with one record on each page and with the text above and bellow each record. I was making it with Directory mail merge. What I noticed is that everithing is ok if I try without text and then I get one page with all records in table form. But, I need to have a text also.

    I have to say that I was reading some tutorials which I found on the net, but I didn't solve it as mostly no one is talking with some text (or I didn't find it)

    How can I solve this issue?

    Thank you very much in advance.

    Best regards

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,978
    Thanks
    0
    Thanked 208 Times in 189 Posts
    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 at:
    http://windowssecrets.com/forums/sho...merge-Tutorial
    (It's a Sticky thread at the top of this forum)

    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
    http://windowssecrets.com/forums/sho...l=1#post928391

    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
    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
  •