removing duplicated email addresses

[peter renton]

Hi

i have attached a sample work book

i have a long list of data that is imported from another platform, the report only pulls in the staff members name, so i have a helper formula in column i that adds a . to the name and then
another in k that converts it in a valid email. the macro then adds these to a new email so i can blanket email all members. my question is what do i need to add to stop the code adding duplicate addresses to the new email?


Regards

Peter

[Fluff13]

How about

Please Login or Register  to view this content.

[peter renton]

Hi Fluff13

Thank you very much that works spot on :-)

Peter

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Fluff13]

Hi Fluff13

Thank you very much that works spot on :-)

Peter

Glad to help & thanks for the feedback