+ Reply to Thread
Results 1 to 2 of 2

MailMerge-Couldn't implement page break and couldn't eliminate header repeat for each reco

  1. 02-05-2015, 04:26 PM #1
    avid.developer8
    avid.developer8 is offline
    Registered User
    Join Date
    02-05-2015
    Location
    Tx
    MS-Off Ver
    2013
    Posts
    1

    MailMerge-Couldn't implement page break and couldn't eliminate header repeat for each reco

    Hello,

    Any help is greatly appreciated!

    I am trying to create a mail merge from question and answers from the spreadsheet. I have attached the word template and spreadsheet as well.
    There are 2 issues that are currently facing right now.
    Issue1: I am trying to include a page break after each group of UniqueIDs
    Issue2: The header repeats for each record in the table. My task is to make sure there is only one table header for each group of uniqueIDs.
    <<Please see screenshot>>

    Again, I greatly appreciate your time and effort in assisting me with this project.

    Thanks,
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-05-2015, 05:44 PM #2
    macropod
    macropod is offline
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,796

    Re: MailMerge-Couldn't implement page break and couldn't eliminate header repeat for each

    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
    or:
    http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
    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 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
    [Fmr MS MVP - Word]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] List all worksheets that couldn't be unprotected
    By Smally in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2014, 06:15 PM
  2. [SOLVED] Tried to Build a Macro, but couldn't make it repeat for multiple rows.
    By homike2 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-06-2013, 09:37 AM
  3. Available resources
    By Miramar in forum Excel General
    Replies: 1
    Last Post: 01-11-2013, 10:21 AM
  4. [SOLVED] Code couldn't works
    By jackyong1985 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-19-2012, 04:54 AM
  5. i couldn't open my excel files,it gives location couldn't find err
    By Hozefa in forum Excel General
    Replies: 1
    Last Post: 12-21-2005, 12:10 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1