Email same email addresses' data onto one email

Dear all

On the attached sheet I have a list of suppliers that I paid. The list changes daily. I have an Email button when I click the Email button I like to send to email to each email address by copying the related rows, if it is the same email address I only want to send one email. At the moment it copies everything onto one email.
here is the button code

Please Login or Register  to view this content.

This works perfectly thank you very much,

but only one thing, if it is same email address for deferent persons it lists all of them in one email, is there way to produce different email for different person even though they have same email address?

Sorry I was on holiday, I just saw your reply jaslake

You are absolutely a star. it works perfectly, I hope this also help all the others who is looking for this kind of email solution.

Thank you so much

Originally Posted by jaslake

Hi lapot

What do you wish to happen if the Email Address is empty?
Attachment 439973

I like them show as empty on the email then I can manually type it. We are trying to update email addresses on our system so that eventually there will be no empty ones, but mean the time empty ones we can manually type.

can we do this please?

thanks

that works perfectly thank you very much. I wish you should show me what you changed in the code but you are a star, I really appreciate your help.

Thanks for this very helpful

Also I was studying your code and couldn't find an answer for "Cel" that you assigned as variable relating this code. Don't we usually say something like Cel = ....... if we did Dim Cel as String, or Range

Please Login or Register  to view this content.

my break point doesn't show that only when there is an error and yellow highlighter come up the I can hover over lines and see values, you are too advance anyway , it will be hard for me to understand whole code. I wish I could be like you

respect