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

    Question Problem with last record when using Quote and Set Key in mail merge

    Word 2013

    I'm doing a many to one mail merge. See attached file for my code. On the last letter, the quote text is not printing. Can anyone help me to get this working? Although creating a dummy record works, it's not a viable solution.

    SaraMailMerge2.docx

    Thank you for your help.

    Jessica
    Attached Images Attached Images

  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
    The merge process to which you refer is based on my tutorial (http://windowssecrets.com/forums/sho...Maths-Tutorial) and requires the datasource to contain either:
    • a dummy last record for the Key field, containing nothing more than a 0; or
    • each group to contain a field from which the last record in the group can be identified.

    If neither of those options is viable for you, 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

    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]

  3. #3
    New Lounger
    Join Date
    Jun 2015
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by macropod View Post
    The merge process to which you refer is based on my tutorial (http://windowssecrets.com/forums/sho...Maths-Tutorial) and requires the datasource to contain either:
    a dummy last record for the Key field, containing nothing more than a 0; or
    each group to contain a field from which the last record in the group can be identified.

    If neither of those options is viable for you, 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

    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
    Thank you!

Posting Permissions

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