Results 1 to 1 of 1
  1. #1
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,770
    Thanks
    0
    Thanked 162 Times in 150 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:
    http://support.microsoft.com/?kbid=211303
    and:
    http://support.microsoft.com/kb/294686/en-us
    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.

    Enjoy
    Attached Files Attached Files
    Last edited by macropod; 2014-02-07 at 01:27. Reason: Additional content
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

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

    301MD (2014-02-03),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
  •