brianharris16
Member
Hi, I have created a shift turnover spreadsheet in Excel and with VBA I am allowing the users to generate an e-mail in Outlook which will send the spreadsheet in the body of the e-mail.
What I am looking to do is have the Subject line in Outlook be based on the system time. For example if the time is 0715 the the subject would be "3rd Shift Turnover" if the system time is 1515 then the subject line would be "First Shift Turnover" and so on.
Using Office 2007 and Word as my editor for Outlook.
What I am looking to do is have the Subject line in Outlook be based on the system time. For example if the time is 0715 the the subject would be "3rd Shift Turnover" if the system time is 1515 then the subject line would be "First Shift Turnover" and so on.
Using Office 2007 and Word as my editor for Outlook.