I have a big task and I don’t know if this can be done through VBA.  Let me explain what I need to be done.

1.  I have several clients that I setup an email address through Exchange server (not my personal outlook inbox) with a user name and password.

2. Then I have several customers that sending email attachment for that particular client.  Let say one of the client’s name Troy Corporation and the email will be email address removed for privacy reasons.

The customer’s name is: Daybreak Fast, FedEx Freight, R&L Carriers, and TRN Logistics.  All the customers are sending email attachment into Troy Corporation mailbox. Side Note: (sometimes I have different customer send the attached file. Let say this I have this week Mr. email address removed for privacy reasons and next week I have Mrs. email address removed for privacy reasons I need the program to check for both emails to see if one of them send me a file.

What I need is to do is login to mailbox (Troy Corporation) retrieve each email with the attached file for each customer, then download them to my network folder.  If I did not receive an attachment for any of the customer to send them a second request with a note on the body “we did not receive your file” something like that.

3. So, when I login for second time to retrieve the remaining attached file. But if I did receive the email attachment either on the first or the second attempt, the customer SHOULD NOT RECEIVE a second request because I did receive their file.

I do have more after all the files are download to my network folder.  But I want to know if this can be done through Power Shell.

​I have a big task and I don’t know if this can be done through VBA.  Let me explain what I need to be done.1.  I have several clients that I setup an email address through Exchange server (not my personal outlook inbox) with a user name and password.2. Then I have several customers that sending email attachment for that particular client.  Let say one of the client’s name Troy Corporation and the email will be email address removed for privacy reasons. The customer’s name is: Daybreak Fast, FedEx Freight, R&L Carriers, and TRN Logistics.  All the customers are sending email attachment into Troy Corporation mailbox. Side Note: (sometimes I have different customer send the attached file. Let say this I have this week Mr. email address removed for privacy reasons and next week I have Mrs. email address removed for privacy reasons I need the program to check for both emails to see if one of them send me a file.What I need is to do is login to mailbox (Troy Corporation) retrieve each email with the attached file for each customer, then download them to my network folder.  If I did not receive an attachment for any of the customer to send them a second request with a note on the body “we did not receive your file” something like that.3. So, when I login for second time to retrieve the remaining attached file. But if I did receive the email attachment either on the first or the second attempt, the customer SHOULD NOT RECEIVE a second request because I did receive their file.I do have more after all the files are download to my network folder.  But I want to know if this can be done through Power Shell.  Read More

​