Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2012
    Posts
    7
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Categorizing MailMerge on ONE Page - Directory/Catalogue

    I am trying to get the mail merge work with directory as the source that would help me categorize the records in my current template.

    I am using this field code:
    {QUOTE{IF{MERGESEQ}=1{SET Key ""}}"{IF{MERGEFIELD Description}<> {KEY}"{IF{MERGESEQ}>1" "} Values for {MERGEFIELD Description}{SET Key{MERGEFIELD Description}} Input "}{MERGEFIELD ColDesc} "}

    Now the output I get is fine for a new fresh document, but when I try this code with an existing template, what it outputs is a document for each record it merges.

    What I would like to have is a kind of this output on one page:

    Details for the record selected from the file provided:


    Values for 'Subjects'
    Input
    Study ID
    Class ID
    Subject Name
    Student ID

    Values for 'Visits'
    Input
    Visit ID
    Visit date
    Room No.
    Summary
    etc.....
    But what my output is the following:

    Details for the record selected from the file provided:
    Values for 'Subjects'
    Input
    Study ID
    Class ID
    Subject Name
    Student ID


    Details for the record selected from the file provided:
    Values for 'Visits'
    Input
    Visit ID
    Visit date
    Room No.
    Summary



    I agree by default, Mail Merge using directory tells word to repeat all the contents in the sheet. ref: http://lis.dickinson.edu/technology/...tory_merge.pdf . But I wanted to have the output my way.

    All suggestions are appreciated.

    Best

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Given your post here: http://windowssecrets.com/forums/sho...l=1#post876576, it's not clear whether you're still having problems.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Tags for this Thread

Posting Permissions

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