Forum Discussion
drop-down list vs if-then vs ??
mathetesThank you for your reply! I've looked into the mail merge function and agree it looks like something I could create, but the problem is that I will not be the one actually using this to create the final reports - rather it will be about a dozen different people creating reports for their respective classes, and I'm not sure that it would be feasible for them all to go through this process even after I set up a template. The best possible scenario is where there is only one program for them to deal with. One of the instructors has told me that in a previous job, he had an excel file with all the drop-down choices to select, and the text would appear in a larger cell below as he went through all the drop-downs. Is there a way to have something like the mail merge program be embedded in the excel document?
Thank you!
Oh, my. That IS a challenge. My own sense, however, is that getting something like that to work solely in Excel would actually be more difficult for that diverse group of instructors--especially if they're older folks (I say that as a 78 year old; I'm well aware that most of my contemporaries aren't as comfortable with computers as am I)--than would something using Word. More people are more familiar with Word, in general, albeit not with mail merge....
And to produce a series of letters for different students (or whatever), in Excel, would require a VBA or macro routine, whereas in Word mail merge that's exactly what it does with whatever population has been selected.
But I'll defer to others here who may have had experience producing the kind of letter you're describing from Excel. I know it's got remarkable capabilities, and know also that I've not tapped into all of them.