J
JP SIngh
We are developing a helpdesk application and would like to add the ability
to create call (records in the database) automatically from the email sent
to a specific mailbox.
For example if the user sends a mail with "New" in the subject line then we
want to run a SQL statement like this
Insert Into Calls (Subject, Details) Values ( EmailSubject , EmailBody)
We would also like the possibility to update record with the information
i.e. if someone sends an email with the following subject line
Update: 204
i.e. update record id 204 with the information contained in the email
hence the query will be
Update Calls Set Description = EmailBody where id=204
I have look around and it appears this can be done through VBScript or VBA
or VB. Has anyone done anything like this before? Any code links or sample
code to modify.
The application and the database will be internal and we are running mixture
of Outlook 2003/2000 on Microsoft Exchange server 2000
Any help is greatly appreciated.
to create call (records in the database) automatically from the email sent
to a specific mailbox.
For example if the user sends a mail with "New" in the subject line then we
want to run a SQL statement like this
Insert Into Calls (Subject, Details) Values ( EmailSubject , EmailBody)
We would also like the possibility to update record with the information
i.e. if someone sends an email with the following subject line
Update: 204
i.e. update record id 204 with the information contained in the email
hence the query will be
Update Calls Set Description = EmailBody where id=204
I have look around and it appears this can be done through VBScript or VBA
or VB. Has anyone done anything like this before? Any code links or sample
code to modify.
The application and the database will be internal and we are running mixture
of Outlook 2003/2000 on Microsoft Exchange server 2000
Any help is greatly appreciated.