First off, I want to acknowledge the list for being so helpful to me. I appreciate the assistance provided on my first couple of inquiries!
I am working on the date item you all helped me with already and then it occurred to me that I have another situation that I need to solve somehow and I would prefer to keep my solution centered around the iSeries, if at all possible. So, I am posting here to see what you all think.
Here is my situation:
I have someone that is sending me a CSV that is attached to an email. Our email server is MS Exchange.
At this time I assume that email will arrive in an Exchange mailbox and I need to retrieve it from there.
I am looking for a way to retrieve the email, save the attached CSV to the IFS and process it from there. All this would be done from the iSeries somehow versus using VB/Outlook or something like that.
That's my ideal situation at least but I am open to other options or ideas as well. We do not host any sort of email on the iSeries and I do not see that changing. That being said, perhaps some sort of limited mailboxing on the iSeries would work where Exchange could forward the email to the iSeries?
Just thinking out loud there.
Any ideas on how to best pull this off are appreciated.