Mail Merge with IF statements

[MEL]

I work at a college and we are creating a document that pulls in all of our students coursework to form a list of their credentials. It has to be merged from Excel. The problem is that any student can have any number of credentials. I cannot make my merge continue searching for additional courses after it has looked at the first. Does anyone know how to make the merge loop to continue? Another problem is that I need to check the courses again laterin the document to see if any are internships. A final complication to this process is that the courses are saved in Excel as a letter then you have to check the next column to see what grade they received to decide what to print out as their ability. So there will be a nested IF but I dont know the easiest way to do it. Help!!!!

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP