Exchange/SQL/VB/Outlook (and possibly a little DDE for good measur

Hi Peoples,
- This is also logged in Exchange server Development Thread -
First let me start by saying I'm not sure if this is in the correct thread -
so a million apologies if it is a little of topic (and for the duplication).
Now...
I have a Windows Server 2003 environment with the following config:
- 2003 Server Enterprise (SP1)
- SQL Server 2000 (SP3)
- Exchange 2003 Enterprise (SP1)
- Outlook 2003 (Office 2003 SP1)
- 3rd Party Help Desk Software with SQL backend (and DDE engine if relevant)
The situation is this - If an email (with a specially formatted Subject
probably) is sent into my environment I would like (either via DDE, SMTP
Event Sink or VBScript) to have the data, subject and sender address of the
email (not taking into consideration any error handling at this stage)
dropped into SQL databases(s). Basically auto-generating a Helpdesk Job with
the emailed data.
I've tried tinkering with DDE - but on the whole have had limited to no
success with it, even at the most simple level. Correct me if I'm wrong, but
it (DDE) is painful, yeah? :)
I'm not clear whether this can be achieved through SMTP Event Sinks (though
I assume it can), or if this is really the most suitable solution.
I'm quietly confident that VBScript running on an XP box with Outlook 2003
with some simple "Rules" in place this could be achieved, but this is ugly
and a bit of a hack solution.
I have the site replicated in a Dev environment so I am in a position where
testing and so forth is feasible for a while.
If someone could shed a little light on the situation, and possibly offer
some direction/ideas that would be fantastic.
Thanking you in advance..
Matt.Hi
You may want to check out SQL Mail and the documentation in books online
regarding
xp_findnextmsg and xp_readmail
John
"Matty B" <MattyB@.discussions.microsoft.com> wrote in message
news:A1C3547E-0C2C-4765-ABD4-81610A9AB047@.microsoft.com...
> Hi Peoples,
> - This is also logged in Exchange server Development Thread -
> First let me start by saying I'm not sure if this is in the correct
> thread -
> so a million apologies if it is a little of topic (and for the
> duplication).
> Now...
> I have a Windows Server 2003 environment with the following config:
> - 2003 Server Enterprise (SP1)
> - SQL Server 2000 (SP3)
> - Exchange 2003 Enterprise (SP1)
> - Outlook 2003 (Office 2003 SP1)
> - 3rd Party Help Desk Software with SQL backend (and DDE engine if
> relevant)
> The situation is this - If an email (with a specially formatted Subject
> probably) is sent into my environment I would like (either via DDE, SMTP
> Event Sink or VBScript) to have the data, subject and sender address of
> the
> email (not taking into consideration any error handling at this stage)
> dropped into SQL databases(s). Basically auto-generating a Helpdesk Job
> with
> the emailed data.
> I've tried tinkering with DDE - but on the whole have had limited to no
> success with it, even at the most simple level. Correct me if I'm wrong,
> but
> it (DDE) is painful, yeah? :)
> I'm not clear whether this can be achieved through SMTP Event Sinks
> (though
> I assume it can), or if this is really the most suitable solution.
> I'm quietly confident that VBScript running on an XP box with Outlook 2003
> with some simple "Rules" in place this could be achieved, but this is ugly
> and a bit of a hack solution.
> I have the site replicated in a Dev environment so I am in a position
> where
> testing and so forth is feasible for a while.
> If someone could shed a little light on the situation, and possibly offer
> some direction/ideas that would be fantastic.
> Thanking you in advance..
> Matt.
>