The dropdown is in excel the datasource! I figured that if I use the substitute function to add the name to the appraisal comment it will work in excel then I merge after to the word document. Thanks for looking at it!