Mail Merge with IF statements

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MEL - 10 Feb 2004 15:41 GMT

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!!!!

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 11 Feb 2004 04:05 GMT

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

Signature

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

>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
[quoted text clipped - 7 lines]
>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!!!!

Reply to this Message