I managed to build a code that does everything except one part: attaching an excel workbook to the mail.
Say if the file location to be attached is in sheet 1, a1 (this is a cell with a formula as this changes everyday)
Is there any code that you know of to get the value of cell a1 and attach the workbook in the macro generated mail? Thanks