Jump to content
Posted 09 December 2013 - 12:04 PM
Posted 09 December 2013 - 04:57 PM
From a 30,000 foot view,
1. A database to retrieve the email (which you already have)
2. A mechanism to recognize when an entry is added to the database.
3. A mechanism to send the email.
In order for this to work, the overall system needs to recognize when there is a new entry. That can be as simple as a daemon that runs every 'n' seconds and checks for new .csv files. At a more complex level, a database trigger could be used to send an email. It depends. What are you using for a database? I don't see any need to worry about Outlook at all, and unless you are already using Access, then that isn't really necessary either.
Sending an email using VBA is trivial, and your choice of language is largely unimportant, but again, it depends.
I'm not sure if that helps much, but I am making guesses about your environment so I am not able to give too much in the way of concrete advice.
Posted 16 December 2013 - 09:59 PM
To work with printers/Faxes VBA or VB6 is actually still prefered language. Im sure you can actually set this up on the print/fax machine. Maybe try enabling the printers like this.
1, printer gets a fax, sends to an email address (This can be achieved)
2. Automate Outlook with said email address to repond with an email to the user who sent the fax based on the phone number (Would have to be in contacts list)
You see where i am going with this?
0 members, 0 guests, 0 anonymous users