I want to loop through all emails in a folder, then loop through all excel attachments in the email, saving each one to the desktop, processing it, and then remove the file.
Should be simple.
The picture above shows what I am doing. I only have one email, but it has two attachments, one is Excel and one is a jpg. I want to loop through each ATTACHMENT in the email and then save any that meet the condition that it is an excel file. However, the Save Attachments to Desktop action works on the MAIL message, not the item returned from the for each. But this makes no sense! I am looping through the attachments in the mail so the for each should return a file.
What is going on?
[As an aside, I know I can kind of get around this by putting in a filter for only XLS files in the save method, but I shouldn’t have to do that as I have already filtered for those files. And anyway, what if I have two or three or one hundred excel files in one email].