Hi All,
I currently have the VB code set to display yesterdays date in an emails subject line, but I need it to display the previous Fridays date instead if the current date is Monday. Additionally, I need the second line in the email body to only display if those same conditions are true. We email reports from the previous work day's data, but on monday we also have the same report to email with additional data. Automating this process will save us quite a bit of work. Thanks!
The original full code was graciously provided by John H Davis here:Please Login or Register to view this content.
http://www.excelforum.com/excel-prog...tus-notes.html
Thanks again!
Bookmarks