I think this can be done in SPD(for moss 2007) but I always do these in
visual studio.
I need to look at an expire date that is in a document library, and then send
out a reminder email like so:
An email when the item is 2 years from expiring,
another when the items is 1 year from expiring,
ETC.