This is what I understood: You want to receive an e-mail warning when a news item is about to expire (be un-published). Is this correct?
You will need to do some coding to do this either as a plugin or a snippet (or a stand alone script). If you want to receive a notification when a document is published/unpublished you can do this with a plugin and use the publishing event as a trigger.