I have a spreadsheet which lists accounts in Column D. In column J I have a simply formula which checks if some figures are correct and places the word MATCH in the coresponding cell if so. In column L I have a list of email addresses which relate to each account number. Column M is the path of the file I would like to attach for each account.
I have the following code which creates and sends emails with attachments, however it always sends the same attachment as it looks at a set path. Is there anyway the code can be amended to look at the file path in column M and attached the file?