Put in a formula in an adjacent cell the tags the customers

if F2 as an example
=if(D2<DateSerial(Year(Today())-1,Month(Today()),1),"Send To","Don't Send
To")

Then drag fill down the column for as long as you have data.

Obviously the condition of checking the date in Column D against a date a
year prior to today is notional and would be replaced with the conditions
that identify the data in a row as a current customer.
--
Regards,
Tom Ogilvy


"Dave" wrote in message
...
I want to tag customers in a prospect list from a current customer list
so I don't send advertising to current customers only prospect