Hi @Solus Rankin, thank you for taking the time to reply to my post.
I'm unable to post a worbook at the moment, but I can confirm that the values in column C is the mail address for the recipient and the values in columns E and F are the file paths to the files.
Having looked at this throughout the day, the main issue I have is that I'm unable to adapt the code so that the script starts looking for the values in columns E and F starting at row instead of row 1. I can sort the rest out.
I did try the obvious and change the reference of row 1 to row 4 and the relevant columns in the following section of code, but the email wasn't created, so I've clearly done something wrong.
'Enter the path/file names in the C:Z column in each row
Set rng = sh.Cells(cell.Row, 1).Range("C1:Z1")
Many thanks and kind regards
Bookmarks