How can I mail merge using filtered data from excel
 

Office 97 I want to create mailing labels from excel. I have AutoFilter
turned on and will use it to select the recipients (which will vary each
time). I want to automate this procedure, at least the mail merge portion.
I would like to eventually set up a macro to print the labels, but I can't
get it to work manually yet. My mail merge will not let me select the
Filtered data. I have even copied the filtered sheet to another sheet. Any
help would be appreciated.