Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Sep 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am trying to create a mail merge letter which needs to include several records, a repeating detail section, on each letter. It is for teaching contracts and needs to list each class for the teacher. Some teachers have only 1 class but others have anything up to 5. I'm using an excel file as the data source.

    The fields are similar to: TeacherID, Name, Subject, Class, HourlyRate, Hours. I've looked at the NEXTIF option but can't figure out how to make it work...
    Cheryl =^..^=

    IS Support, Adelaide <img src=/S/granny.gif border=0 alt=granny width=20 height=20>

    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

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

  3. #3
    Star Lounger
    Join Date
    Sep 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I looked at the tutorial but it didn't seem to do what I wanted.

    I need to have a basic mail merge with the possibilty of repeating 3 or 4 fields for some documents. Maybe I'm just having a slow brain day
    Cheryl =^..^=

    IS Support, Adelaide <img src=/S/granny.gif border=0 alt=granny width=20 height=20>

    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    In macropod's examples, the data are grouped by City or by State; the same principle would apply to your mail merge, with TeacherID as field to group by.

Posting Permissions

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