BobBridges, Thanks so much for your help! Unfortunately I am not very familiar with VBA. Although I have begun the process of learning it, at this point I can't do much more than open the visual basics window.

Everything you said made sense to me, I just don't have the skills at this point to apply it. Can you elaborate more on how to actually transfer the code or maybe write the code in excel to automatically open and use word? Idealy I would like to be able to enter information into a single cell on excel and then have excel automaticaly use word to process the data into parts and send it back into the excel sheet to appear in a column.

Hopefully I've correctly understood your response, and I appreciate the help!