Email Order Processing

Justin

Hello

We have the need to be able to extract sales orders from the body of an email and insert them into navision. The orders are generated electronically by our customer and contain all the necessary product codes etc. The body of the email is not csv or xml so we will have to develop a program to pass through the file and extract the important information.

The first issue is extracting the email from an exchange mailbox (without having someone saving the contents to a file manually and running a program)

I have seen details of navision sending email but not recieving it ? Perhaps someone hase some ideas. Does navision have hooks into exchange or perhaps POP3?

Thanks in advance,

Justin

PS: We are running exchange 2000 and navision/sql 3.6

mstallmann

Exchange is very flexible...here is what i would do:

Create an Exchange mailbox that either you have you customers send emails to, or that your users move messages to when they recieve orders.

Then, you can either use the code in the Navision Email Logger code unit (5064) to see how to retrieve messages from Exchange within Navision, then using their example, you can parse through the email message and create an order accordingly...

or

Create custom rules using a VB macro to parse messages in that folder, and then use Navision ODBC, or OCX to insert the order into the Navision Database...

Mike