+ Reply to Thread
Results 1 to 2 of 2

Mail Merge problem - Header Title doesn't match data

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Mail Merge problem - Header Title doesn't match data

    I am trying to create a mail merge document where there is a page split every time an establishment changes with the title of the establishment at the top of each page (this is within the header). I have almost managed to do this using "Mergeseq" and "if" fields, however when I run the final merge document, the establishment header is always one in front of the data and no matter what I try, I cannot get the right establishment on the same page as the data (within the header). If I put the establishment header within the main document, this shows the right information, but repeats for each separate record which isn't what I want...

    Basically, I'd like a list of people from each establishment, with the establishment title at the top of the page and a page break every time the establishment changes showing the same info for each change. Can anyone suggest a work around for this please? I've attached some screen shots. 1 is the mail merge, 2 is the data, and 3 is what I would eventually like the page to look like (with data in it).

    Last edited by shrew82; 08-25-2017 at 05:42 AM.

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010

    Re: Mail Merge problem - Header Title doesn't match data

    Your screen-shot showing the field coding looks like it is based on my Microsoft Word Catalogue/Directory Mailmerge Tutorial, available at:
    Because Directory merges don't ordinarily use Section breaks, mergefields in the page header don't work. If you need the content of part of the body content to appear in the page header, format that content with a unique Style name, then use a STYLEREF field in the header to reference that Style.

    There is nothing you can do to achieve the desired outcome with content that does not appear in the document body. Even if you replaced the {QUOTE 12} field with a quoted 'Next Page' section break and unlinked the second section's header from the first, the only header content you'd ever get is that for the group after the one you want the header for...
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Running Word Mail Merge from Excel 2010 - Mail Merge workbook fails
    By pl05.lau@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  2. [SOLVED] Mail merge code- but WORD doesn't close properly
    By wrightyrx7 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2014, 06:55 AM
  3. INDEX:MATCH with header title that has spaces?
    By ks100 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2014, 02:11 PM
  4. VBA code doesn't perform mail merge
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2013, 09:29 AM
  5. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  6. Problem with moving numberic data read in mail merge add .00001 after all numrict value
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-27-2012, 03:47 AM
  7. Title Case--No mail merge
    By Derek Y via OfficeKB.com in forum Excel General
    Replies: 3
    Last Post: 07-29-2005, 03:05 PM


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1