I have some code that sends an email to the list of people in a selected range, but recently there have been duplicates in the range due to the way the data is keyed.
Is there any way of adding in some code that checks if the name has already been actioned and so skip that entry.
The email addresses are in column A and I just select the range I want (eg A2:A1500) then run the macro on that selection.
Hope someone understands this, as I don't think I've explained it very well.
Cheers,
bruty
Is there any way of adding in some code that checks if the name has already been actioned and so skip that entry.
The email addresses are in column A and I just select the range I want (eg A2:A1500) then run the macro on that selection.
Hope someone understands this, as I don't think I've explained it very well.
Cheers,
bruty