My current process is:
Get Outlook mail (unread only) >> output all mails to text file >> save each individual mail date as a separate date variable >> use switch to capture all details in email table and transfer to Excel
How do I achieve the bolded step above and format it as 10 July 2019 ?
Question 2: How do I save to a networked drive if there is no direct link/URL I can use?
Question 3: How do I filter the current balance for a certain category in Excel, grab the Balance, email to XX recipients at the last step?
Problem is, each email is for a certain category, but they are all consolidated in 1 Excel sheet. Filtering the balance for Category A based on the consolidated sheet seems tough.