Results 1 to 1 of 1
  1. #1
    Super Moderator
    Join Date
    May 2002
    Canberra, Australian Capital Territory, Australia
    Thanked 467 Times in 380 Posts

    Microsoft Word Catalogue/Directory Mailmerge Tutorial

    Attached is a tutorial on how to use Word's mailmerge facility to create lists sorted by category.

    Microsoft has similar articles at:
    but my tutorial goes way beyond those articles' scope by:
    a ) providing a sample data source that can be used to demonstrate/test the use of different keys,
    b ) including working mailmerge fields
    c ) adding examples to show how:
    . text can be categorised using two keys
    text can be added after the repeated data
    group and sub-group counts and totals can be calculated without the need for such fields in the source data
    to create a two-column output
    to create a series of tables from the merged data
    to shade alternate rows when merging to a table
    to merge to email
    Plus, unlike the field coding suggested by the MSKB articles, my approach doesn't insert extra lines for Excel data sources.

    Note 1: Please read the tutorial before trying to use the mailmerge main document for a mailmerge - the merge field coding you'll need is in the tutorial and has to be copied from there into the mailmerge main document before you can do a mailmerge.

    Note 2: Any discussions should be made in a new thread - they cannot be added to this one.

    Attached Files Attached Files
    Last edited by macropod; 2018-05-26 at 08:36. Reason: Additional content

    Paul Edstein
    [MS MVP - Word]

  2. The Following 13 Users Say Thank You to macropod For This Useful Post:

    301MD (2014-02-03),bcraig (2017-02-27),Berryblue (2014-11-20),Charles Kenyon (2015-04-11),mcvideo (2015-10-16),pifsony (2015-04-14),qlgdnv.2013 (2016-06-13),Redcatblack (2014-10-30),sosadsosick (2015-01-20),Tami (2015-01-20),TheQ47 (2015-11-17),TillieMarie (2015-04-29),yahianet (2014-03-11)

Posting Permissions

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