rollingzep
Board Regular
- Joined
- Nov 18, 2013
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
Hi All,
I am trying to save Outlook email attachments but looking for the mails with subject as HO Reports/Divn EOD yyyy-mm-dd
The yyyy-mm-dd are the previous working day date. On Mondays, I receive the previous working day(Friday) date on the subject.
How do I format this?
TIA
I am trying to save Outlook email attachments but looking for the mails with subject as HO Reports/Divn EOD yyyy-mm-dd
The yyyy-mm-dd are the previous working day date. On Mondays, I receive the previous working day(Friday) date on the subject.
How do I format this?
VBA Code:
For Each olMail In OlItems
If olMail.subject Like "*HO Reports/Divn EOD [B]yyyy-mm-dd[/B]*" Then
strFile = olMail & ".zip"
TIA