1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Will a merge work

Discussion in 'Microsoft Office' started by deusy, Jan 14, 2010.

  1. deusy

    deusy Flightless Bird

    I would like to have a single generic letter but inside this letter I need to
    put a list of infractions. There are only 18 infractions that can go in this
    letter. But you will not use all the infractions the same but need to chose
    one or more of these infractions and put then in the same place in the
    letter.

    Would I create the infractions in excel and do a merge? Will the merge then
    give you the list where you can check only the infractions that you want? Or
    should I be doing something different. Thanks
     
  2. db

    db Flightless Bird

    you would create an excel
    template of the letter.

    then create a lookup or
    drop down of the infractions
    to conveniently fill in the
    base of the letter.

    ------------

    the above is only one method
    out of several.

    --
    db·´¯`·...¸><)))º>
    DatabaseBen, Retired Professional
    - Systems Analyst
    - Database Developer
    - Accountancy
    - Veteran of the Armed Forces
    - @Hotmail.com
    - nntp Postologist
    ~ "share the nirvana" - dbZen

    ~~~~~~~~~~~~~~~
    >
    >


    "deusy" <deusy@discussions.microsoft.com> wrote in message
    news:A3FE9472-0ACB-4E42-AE50-7EA2ED9B3E91@microsoft.com...
    > I would like to have a single generic letter but inside this letter I need
    > to
    > put a list of infractions. There are only 18 infractions that can go in
    > this
    > letter. But you will not use all the infractions the same but need to
    > chose
    > one or more of these infractions and put then in the same place in the
    > letter.
    >
    > Would I create the infractions in excel and do a merge? Will the merge
    > then
    > give you the list where you can check only the infractions that you want?
    > Or
    > should I be doing something different. Thanks
     
  3. macropod

    macropod Flightless Bird

    Hi deusy,

    Yes, you could keep the miscreant data in Excel, with a separate column for each type of infraction. A Word mailmerge document could
    then list all the infractions for each miscreant in the same place in the letter for that miscreant. You might need to do a bit of
    field coding in Word to suppress blank lines, but that's about it. For more help, I suggest posting in
    microsoft.public.word.mailmerge.fields.

    --
    Cheers
    macropod
    [Microsoft MVP - Word]


    "deusy" <deusy@discussions.microsoft.com> wrote in message news:A3FE9472-0ACB-4E42-AE50-7EA2ED9B3E91@microsoft.com...
    >I would like to have a single generic letter but inside this letter I need to
    > put a list of infractions. There are only 18 infractions that can go in this
    > letter. But you will not use all the infractions the same but need to chose
    > one or more of these infractions and put then in the same place in the
    > letter.
    >
    > Would I create the infractions in excel and do a merge? Will the merge then
    > give you the list where you can check only the infractions that you want? Or
    > should I be doing something different. Thanks
     

Share This Page