Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Mail Merge multiple records (2000 SR1)

    Hi,
    I'm mailmerging to employees but some of them have many jobs. I'd like them to get one letter per person but I'm not sure how to do that. My data is like this:

    <table border=1><td>Employee Number</td><td>Name</td><td>Job</td><td>1</td><td>Bill</td><td>Cook</td><td>1</td><td>Bill</td><td>Cleaner</td><td>2</td><td>Joe</td><td>Cook</td><td>3</td><td>Ian</td><td>Cleaner</td></table>
    and I'd like the letter to come out like:

    Letter 1:
    Bill
    Cook
    Cleaner

    Letter 2:
    Joe
    Cook

    Letter 3:
    Ian
    Cleaner

    Basically what (I think) I need is for word to group the records like Access does in it's reports. Is this possible in Word?

    Thanks in advance,
    Jim MacLeod
    Shetland Isles

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

Posting Permissions

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