locked
Mail Merge only showing the first record even with <<NEXT RECORD>> RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have Word 2010 and created a mail merge document to pull records from Excel, there are 4 rows of records from Excel and I have the merge setup as follows:

    «SumOfShares_Exercised» «NARRATIVE»«Next Record» «SumOfShares_Exercised» «NARRATIVE» «Next Record» «SumOfShares_Exercised» «NARRATIVE» «Next Record» «SumOfShares_Exercised» «NARRATIVE» «Next Record» «SumOfShares_Exercised» «NARRATIVE»

    This allows all 4 records from Excel to show up in a paragraph.  When I hit Preview Results, all looks good, but when I hit print, it updates the merge to show the 1st record 4 times in the paragraph.

    Any ideas?

    Thanks in advance.

    Eddie

     
    Tuesday, October 15, 2013 12:22 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote
    You need to execute the merge, not simply print the preview.

    Cheers
    Paul Edstein
    [MS MVP - Word]

    • Marked as answer by Illumina Eddie Tuesday, October 15, 2013 6:06 PM
    Tuesday, October 15, 2013 4:49 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
    You need to execute the merge, not simply print the preview.

    Cheers
    Paul Edstein
    [MS MVP - Word]

    • Marked as answer by Illumina Eddie Tuesday, October 15, 2013 6:06 PM
    Tuesday, October 15, 2013 4:49 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you very much, that did the trick.  I recorded a macro to print instead of finish and merge to printer.
    Tuesday, October 15, 2013 6:06 PM