View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Reva Reva is offline
external usenet poster
 
Posts: 12
Default 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.