Spool Issue
Question asked by Boyd White - February 13, 2015 at 3:44 PM
On Windows Server 2008 R2 Standard 64-Bit I have installed as my Email Server [SmarterMail Professional Edition Version 4.3.2760]. I have been working on a solution that customers could email an .xls or .xlsx file to an email and using Visual Basic I could either parse the attachment out of the email or save the file to the File System and work with it from there.
I found a work-around by having Microsoft Outlook open and set to download messages from my [ import at domain dot com ] email every three minutes. Using very simple VBA code within MSOutlook I am able to save the Attachments out to the File System which is the primary hurdle I was trying to clear.
Now for the issue, my Server is installed on a blade in a large hosting company and its internal IP is while the IP my website's URL is pointed to is something you would expect like My SmarterMail's [ Protocal Settings: SMTP In: Submission IP: Port] is set to the and works fine.
When I set my MSOutlook, which remember is also running on the Desktop of this blade server, email account's Server Settings to any other than then MSOutlook cannot find the Email Server because it is not sophisticated to go out into the internet then back again, [Example of Server Settings tried: mail.mydomian.com and ].
The problem is, when my MSOutlooks Server Settings are set to the SmarterMail's Spool does not clear out the emails downloaded (transferred) to MSOutlook....within seconds I will have 300 copies and more of the same email downloaded to MSOutlook.
What configuration setting can I set to clear out the SmarterMail Spool in a situation like this where the email is being downloaded on the same computer the Email Server is on?
[Note: I am working over Remote Desktop with my blade server.]
Thanks in advance for any help you can provide.

2 Replies

Reply to Thread
How about setting up a HOSTS file entry pointing to the local IP address OR set up the DNS server included in Server 2008 to do pretty much the same thing?
Further update if anyone is interested in this type of thing. I figure out how to use AfterLogics (afterlogic dot com) Mailbee IMAP4 component to connect to my SmarterMail account using solid VB6 code, open the Inbox, download the emails and collect beaucoup info on the email and attachments, and save the attachments to the File System. The info collected being saved into a database table for use later on. Then continuing on and deleting all the emails in the Inbox programatically to keep the email account clean and ready for the next Import email.
Fairly slick and solid way to provide the solution desired. Run this puppy as a Scheduled Task and my main hurdle is jumped.
Now my users can email MSExcel files containing data in a predetermined format, the idea being data coming from Quickbooks, and it will get imported into a temp database table where the users can confirm the data is correct before approving its full import into our web application.

Reply to Thread