Problem is that I don't really know how things will look...we're in the beginning of a huge software implementation, so I'm drawing up a mock up that will be edited again when we know the actual format. I'm told that it'll just put a bunch of data into csv (I'm assuming we'll use Excel to look at the file) and then the mail merge will use that, and the macros will translate it after that.
Assuming we get a bunch of data, like
name=lastname,firstname
id=123456
condAdmit=yes
ave=82
name=lastname,firstname
id=987456
condAdmit=no
ave=n/a (or blank)
do I need to use 'if...then' statement? I'm mostly stuck on how to build in the logic so that it can decide if a student should get one kind of a letter over another. VBA is so new to me - I'm working on this with a textbook beside me.
Do you think I'm going about this the right way?
