Consulting

Results 1 to 3 of 3

Thread: Remove Mail Merge Fields From All Headers & Footer (Except Page Numbering)

  1. #1

    Remove Mail Merge Fields From All Headers & Footer (Except Page Numbering)

    Just wondering can anyone help with this?

    I need to remove all Mail Merge (convert to text / leave same formatting) from All Headers & Footers (while leaving page numbering as is).

    All attempts at this so far have worked for the first header, but stop when the page changes to landscape.

    Also, is there a way to link headers between landscape / portrait pages changes?

    Greatfull in advance!

    Thanks,
    James.

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    Cross-posted at:
    Macro to Remove Merge Fields / Format Black (All Headers) (msofficeforums.com)
    WORD: Macro to Cycle Through Headers & Remove Merge Fields / Change Formatting to Black | MrExcel Message Board
    (Answered at the latter)
    Please read VBA Express' policy on Cross-Posting in Rule 3: http://www.vbaexpress.com/forum/faq...._new_faq_item3
    Quote Originally Posted by jimmycooker View Post
    Also, is there a way to link headers between landscape / portrait pages changes?
    Yes - simply use the 'same as previous' option. Do note, though, that the header/footer layout won't auto-adapt to the changes in page widths.
    Last edited by macropod; 07-12-2022 at 12:12 AM.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    VBAX Contributor
    Joined
    Jul 2020
    Location
    Sun Prairie
    Posts
    118
    Location
    To have header/footer width adapt between portrait and landscape use Alignment Tabs.

Posting Permissions

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