Thank you, I have made the paths relative and managed to send an attachment by removing the recordset attachment. I think the problem I was having before was if the recordset is empty (or if there is a value in the recordset but there isn't an attachment on the entered value.)
Is there a way to say send attachment only if there is an attachment? I would need this on both the entered value attachments and the recordset value attachments.