Mail Merge Question - Repeating Info

NiGHTSNiGHTS San Diego Icrontian
edited June 2007 in Science & Tech
Hey guys,

I've got a data list from excel of student athlete names, classes, tutors, and a description of the tutor meeting. The problem I'm running into when creating a mail merge is that I cannot get the different classes and tutors to show up - only a repeating match to the first hit on the excel document.


So, instead of getting this in my Word document:

Steve Jobs Math 90 John Class went well today.
Steve Jobs Psyc 110 Bob Missed appointment.
Steve Jobs Hist 112 Andy Class went very bad today.

I get:

Steve Jobs Math 90 John Class went well today.
Steve Jobs Math 90 John Class went well today.
Steve Jobs Math 90 John Class went well today.



Any ideas? :confused:

Please don't tell me I'm going to need to use Access... :(

Comments

  • NiGHTSNiGHTS San Diego Icrontian
    edited May 2007
    Friendly bump, please let me know if you guys need further explanation/clarification.
  • the_technocratthe_technocrat IC-MotY1 Indy Icrontian
    edited May 2007
    NiGHTS wrote:
    Friendly bump, please let me know if you guys need further explanation/clarification.

    try adding <<Next Record>> to the end of each line

    If that doesn't work, jus do the letters and labels wizard, and make a custom labe sheet w/ labels as wide as the page and about 1 line tall... :bigggrin:

    Doing it that way should handle anything from one entry to many pages of entries...
  • NiGHTSNiGHTS San Diego Icrontian
    edited June 2007
    No dice, Techno. I've tried [PHP]<<next result>> <<next record>> <<next>> <<>> and <>.[/PHP]

    I'm using Word 2003, for anyone else that wants to give it a shot. I'm very limited in my mail merge options, apparently; according to the wizard, at least.

    I'll make a trip down to the IT dept. if worse comes to worst.
  • NiGHTSNiGHTS San Diego Icrontian
    edited June 2007
    An update:

    After looking on MS's website, I've discovered the following page: 294686

    And here is what my edited work would look like:
    [php]{ IF { MERGESEQ } = "1" "{ MERGEFIELD NAME "" }
    { SET Place1 { MERGEFIELD NAME}
    { If { Place2 } <> { Place1 }"
    { MERGEFIELD NAME }

    { MERGEFIELD CLASS } { MERGEFIELD DATE } { MERGEFIELD DESCRIPTION }" "{ MERGEFIELD CLASS } { MERGEFIELD DATE } { MERGEFIELD DESCRIPTION }" }{ SET Place2 { MERGEFIELD NAME }}[/php]

    So, I've plugged it in, but ...being a word processor, all it displays is the text shown above. How do I get to to be recognized as a command, rather than text?
  • jaredjared College Station, TX Icrontian
    edited June 2007
    Look under Tools -> Macros ->
    Visual Basic Editor
    Microsoft Script Editor

    I think it is one of those, but I haven't done anything like this in forever. Good luck

    cheers :jared:
  • vip211vip211 KSA
    edited June 2007
    jared wrote:
    Look under Tools -> Macros ->
    Visual Basic Editor
    Microsoft Script Editor

    I think it is one of those, but I haven't done anything like this in forever. Good luck

    cheers :jared:


    gooooooooooooooooooooooood
Sign In or Register to comment.