I am trying to find the best method for processing emails with attachments as they arrive. I can easily create a com object that binds to the OutlookEvents NewMail method but am having trouble negotiaiting the dreaded Outlook Security features.
What I want to do is go through the inbox and :
1. Take note of the sender's email address (having trouble with Outlook security here - have tried Outlook events and CDO)
2. Get the contents of the attachment(s) and import into a VFP table
3. Copy the attachment to a folder determined by the sender
4. Move the email to a processed folder.
I don't seem to be able to get around the security which is no help as the emails will be coming to an unmanned server.
Is there a better way to do this ? Can I make Outlook automatically save emails to a directory and do the processing outside of Outlook ? (Obviously not knowing the sender's email address and using file naming conventions instead)
Cheers,
Jamie