Duplicate attachments when using Excel VBA to email

Hi

Can anyone help with the following issue. I want my code to avoid sending multiple emails to the same address, each line in the spreadsheet will have its own attachment, where there is a duplicate email address it should add all attachments into one email. Each time I run the code at the moment it is only creating one email per address but it is duplicating the attachment from the first line instead of adding from the next.

Please Login or Register  to view this content.

Thanks

Thanks! Fixed with the following:

Please Login or Register  to view this content.