As far as I know, it’s not possible to do this with Hazel. It doesn’t know how to control Mail. Rather, it works with files. You could make Hazel delete certain of Mail’s files, but it’s not a good idea to delete files out from under an application that’s managing them.