Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2016
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy Mail Merged letter with multiple data entry - Please help

    Dear all

    Please I need the code or formula to do a mail merge letter with multiple data entries, without having to send multiple letters to the same clients

    I tried using the code below, but is no working and am kind of frustrated.

    {QUOTE{IF{MERGESEQ}= 1 {SET Place ""}}"{IF{MERGEFIELD City}<> {Place} "{IF{MERGESEQ}= 1 "" "<ENTER>
    "}{MERGEFIELD City}{SET Place {MERGEFIELD City}}<ENTER>
    < ENTER>
    "}{MERGEFIELD Employee}<TAB>{MERGEFIELD Sales}<ENTER>
    "}<ENTER>

    Can someone please help with the correct code using the sample excel and word attachment below or provide me with detail explanation of the code that I can use



    The key field is the Parent name.

    The source data (excel) is attached and sample letter.

    The details that I want on in letter for each parent name is as shown below;

    Company Code:
    Legal Entity:
    Business Address:
    City:
    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
    This subject is fully covered in my Microsoft Word Catalogue/Directory Mailmerge Tutorial, which you can download from the 'Sticky' thread 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.

    The required field coding is complex. However, since the tutorial document includes working field codes for all of its examples, most of the hard work has already been done for you - you should be able to do little more than copy/paste the relevant field codes into your own mailmerge main document, substitute/insert your own field names and adjust the formatting to get the results you desire. 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

    Another option would be to use a DATABASE field in a normal ‘letter’ mailmerge main document and a macro to drive the process. An example of this approach can be found at: http://answers.microsoft.com/en-us/o...1-1996c14dca5d
    The DATABASE field can even be used without recourse to a mailmerge. An example of such usage can be found at: http://www.msofficeforums.com/mail-m...html#post67097

    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 http://bit.ly/1hduSCB
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    New Lounger
    Join Date
    Oct 2016
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Paul, but I still can figure it out even after reading your manual.

    Stephen

  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
    Did you look at any of the worked examples I directed your attention to?

    For your purposes, you'd use the tutorial's example titled Inserting Content Before the Repeated Data or the example titled Inserting Content After the Repeated Data, depending on whether you have any content following the grouped data.

    For the most part, all you should need to do is to copy the field codes to your own document, then edit the letter content and mergefield names to suit your data.
    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
  •