Email Sheet Based on Sheet Name in Col G on sheet "Macro"

[Howardc1001]

I have the following code below which works except it duplicates Hi in the body for e.g Hi Hi Dave instead of Hi Dave


It would be appreciated if someone could amend this section this is causing the issue

Please Login or Register  to view this content.

[6StringJazzer]

Delete this line of code:

Please Login or Register  to view this content.

[Howardc1001]

Thanks

I managed to get this code to work. However, If where there are 2 or more Items in I2 onwards , several emails are created

Please Login or Register  to view this content.

[Howardc1001]

I managed to work out a solution

Please Login or Register  to view this content.