I?m trying to create a mail merge that will merge with different letters depending on the code that is in the field named ?LETTERCODE?. I have 48 different letters and a database of 10,000 names. I would like to be able to do this automatically and not have to choose which names get which letter manually.
I am using MS Word 2002 on Windows 2000. My database is a Progress csv file that can be converted to Excel 2002.
I found this code in the MS Word Help files under ?If Statement?. I don?t know how to write the actual code that would do 48 if ? then ? else statements.
{ IF { MERGEFIELD LETTERCODE } = “1” “{ INCLUDETEXT G:\\worddocs\\contract.doc }”
{ IF { MERGEFIELD LETTERCODE } = “2” “{ INCLUDETEXT G:\\worddocs\\contract2.doc }”
{ IF { MERGEFIELD LETTERCODE } = “3” “{ INCLUDETEXT G:\\worddocs\\contract3.doc }”
I would like to have the exact code to accomplish this via a mail merge or a macro that I could run.