Hello
I have a Macro that currently saves the active sheet as a PDF and attaches it to an outlook email. I would like to modify the macro to add the shift name during which it is emailed out on. For example, if the Email is sent out on a Monday morning between 4am and 8am then the subject should read "12B GOC Turnover" however if it was sent out Monday night between 4pm and 8pm then the subject should read "12A GOC Turnover".
We have different shift names during the week that I can add myself once I understand how to code this. I am not much of a programmer and any help is appreciated. Here is the section of the code where it sends the email out.
Please Login or Register to view this content.
Bookmarks