Macro to find string and copy sentence containing string.

[geekgirlau]

Quick query regarding searching for little words ("to" etc.) - did you try setting the .MatchWholeWord property of the search to TRUE?