Duplicate email address

[Shades1970]

Hi I have a work sheet that some times have the same email address in the column more than once. Hen I click on my send email button it looks at the column and generates the email but at the moment it will put the same email in more than once. How can I get the code to only put it in once?

My code is below any help would be grateful many thanks.

Please Login or Register  to view this content.

[KOKOSEK]

Try:

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

I'd change your For..Next Loop to

Please Login or Register  to view this content.

In addition don't cover the whole of column E. Always restrict anything like this to just the used range. Apply a dynamic range name to the column E addresses and use the name in the code

And it's better to use the VBA sheet CODE name not the Excel sheet tab name since this is too easily changed.

A better option still is to simply use the Remove Duplicates functionality at the start of your procedure and avoid the loop altogether. e.g.

Please Login or Register  to view this content.

[Shades1970]

Many thanks guys all works I will mark as solved