OK, perhaps I'm missing somethign here but I get a runtime error at the highlighted line:

arrTypes() = Split(ThisDocument.Bookmarks("bmkTransplantTypes").Range.Text, ",")

-----------------------------

I modified the path of the excel file to where it's located on our network drive.... and modified the bookmark name because in my letter it's named as "TransplantType" .... are there any other changes I need to make for this code to work?

EDIT: And i know what you're gonna ask next.. JB, have you separated the transplant types with commas? And the answer is Yes.