Excel VBA to Attach File And Automatically Send Email

Dear all friends and experts.,

Scenario :- I have to send reports to our boss , with my updated Report daily at 4:00 PM (which will be saved on Desktop) (C:\Users\leenguyen\Desktop\Report\reportIn.xlsx)

I want the Macro to Run and then to attach file and Also, it should pick " Email address " automatically at that time and daily.

Your Help is Much Appreciated. I am not a IT man, so I dont know where to start .

Thank you so much !

Lee nguyen

.
This macro goes in the ThisWorkbook module :

Please Login or Register  to view this content.

This macro goes in a Regular Module :

Please Login or Register  to view this content.

NOTE: You will need to add your manager's email address in the TO field.

If you do not want to first view the email prior to sending, follow the instructions in the email macro for DISPLAY and SEND.

The complete workbook is attached. You should not need to do any coding on your own. Just make the changes indicated above.