Hi Barb, what about the other way around? I have data from Word, which has several rows and columns on a table. I only need certain word with associating date of that word to be captured on a specific field in excel... and this is emailed as a word attachment... help. I have several incoming emails with word attachments, and I only need the name, protocol #, etc certain words and there is a date associated with each word. I want to have the vba search for the specific word and enter it on my excel userform....or excel sheet 1 which is probably easier,,,