Killian,

A couple of follow up questions.

1) I am having some trouble w/ the code you gave me. I get a VBA error saying "User defined type not defined" at the first line where it says:

Dim xlApp As Excel.Application

2) Looking at your example above, I cannot figure out how to list the various transplant types. Where can i put in the variables like Heart, Liver, etc. I'm extremely new to VBA and don't even know what or how to use arrays.

BTW, I'm using MS Office 2002.

===================================================

Here's a little excerpt from the letter:

October 27, 2005


Dear Ms. ?Last_Name?:



Our XXXXXXX is currently requesting transplant program information from institutions interested in participating, and those currently participating in the network. Enclosed are the RFI and/or RFI Addendum(s) for the following transplant programs: Adult Heart, Lung, Liver, Pancrease, autologous, allogeneic and Pediatric Heart, Liver.
......

That last part in bold underline is bookmarked in my document as "TransplantType".