Hello,
I am trying to write an email macro. The Excel sheet currently runs a macro in the background that pulls data from a database and puts it in an excel tab. The excel sheet has numerous tabs of dates with the data. After the current macro runs and updates a tab with today's date, I want to have code that says:
If the sheet = today's date, email the sheet to my email address? Does anyone have any ideas how I can do this?
Thank you!
I am trying to write an email macro. The Excel sheet currently runs a macro in the background that pulls data from a database and puts it in an excel tab. The excel sheet has numerous tabs of dates with the data. After the current macro runs and updates a tab with today's date, I want to have code that says:
If the sheet = today's date, email the sheet to my email address? Does anyone have any ideas how I can do this?
Thank you!