×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Microsoft: Office FAQ

Word Mail Merge

How Can I Use Mail Merge to Create a List Sorted by Category by AyJayEL
Posted: 22 Mar 01

How to Use Mail Merge to Create a List Sorted by Category

The key field to group on is called {Mergefield City}.
Table like this (Sorted by City)
CITY           EMPLOYEE            SALES
Bath           Davies              ú10,500
Bath           Peterson            ú2,000
London         Smith               ú3,000
London         Jones               ú20,000
 
{If{MergeSeq}="1" "{Mergefield City}
" ""}{Set Place1{Mergefield City}}
{If {Place2}<>{Place1}"
{Mergefield City}

{Mergefield employee}{Mergefield Sales}" "{Mergefield Employee}{Mergefield Sales}"}{Set Place2{Mergefield City}}

Will produce this
Bath

Davies ú10,500
Peterson ú2,000

London

Smith ú3,000
Jones ú20,000

There are more details on the Microsoft knowledgebase article How to Use Mail Merge to Create a List Sorted by Category. It also tells you how to force a new page after each group.

Back to Microsoft: Office FAQ Index
Back to Microsoft: Office Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close