I have an Excel spreadsheet that users use to enter data into. They then copy and paste this data into a Word template that then gets mailed. I want to be able to remove the need to copy and paste. Therefore I am looking for a way to get Word to check and see if certain cells are not blank and then take the cell information from another cell. For example. Column A has account #, Column B has Name, Column C is either blank or has an "X" in it. I would like to Word doc to check the cells that contain X's and if an X is there, copy the information from Column A and B. There is multiple rows so it would need ot continue on until it doesn't see any more data in column A. Is this something that is possible and if so, what would be the most efficient way to accomplish this?



Thanks,

Cory

Have you considered mailmerge?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]