Hi,
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
Bookmarks