Simplest way to mailmerge selected data

[Larry_in_Missouri]

I have an Excel spreadsheet with High School Class information. One of the columns (I) is "Email Address". I would like to send all those individuals not having an entry in that column (blank) a regular mailing with mailmerge in Word or just Excel if possible. I know how to find blank cells using "Go To", but I don't know whether to select that data, create a new sheet for just the selected data (which I do not know how to do) or if I can merge just the selected records (data such as First, Middle, Last ,Address, etc) into letters and labels in one step. Any help will be appreciated.

[mgraf]

After you select your data in Word's MailMerge Edit the recipient list and Filter the field "Email Address".