Copy specific cells' datas on to an email.

Dear all
Attached sheet has list of supplier's payments. What I like to do is when I run the macro email the individual email addresses on column B and copying just the related data against that email address.

For example when I email Samuel Phillips I only want to copy his data. Also would it be possible if it is more than 1 entry can we get total under TotalAmount ?

Name SuppliersReference TotalAmount
Samuel Phillips 84550 £250.00
Samuel Phillips 84652 £360.00
Samuel Phillips 85282 £420.00
Samuel Phillips 81254 £200.00

with this code it opens one email and copy all the data. How can we amend this code so that it works like how I described above?

Please Login or Register  to view this content.

Kind regards

Thank you for your answer but it doesn't work as I wanted.
Can anyone help please?

Originally Posted by Tinbendr

Please Login or Register  to view this content.