Matty B
Guest
|
 Posted:
Sat Oct 08, 2005 4:58 pm Post subject:
Exchange/SQL/VB/Outlook (and possibly a little DDE for good |
|
|
Hi Peoples,
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.
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.
|
|
Glen Scales [MVP]
Guest
|
| Posted:
Mon Oct 10, 2005 12:58 am Post subject:
Re: Exchange/SQL/VB/Outlook (and possibly a little DDE for g |
|
|
Are all the messages coming into your Mail System externally eg do you want
to catch email that are sent via you users Internally
Are they all going to one (or more) specific mailboxes or is it you just
want to catch email with a specific subject sent to any user?
An SMTP sink can be used to do this but if its external mail going to one or
two specific mailboxes eg support or info/sales type mailboxes then I would
use a store event sink instead. The place to start would be the Exchange SDK
which you can download from http://msdn.microsoft.com/exchange. This details
what different types of Event sinks that can be used and specifics of the
API's.
Cheers
Glen
"Matty B" <Matty B@discussions.microsoft.com> wrote in message
news:4B477FE3-BF92-41C7-BF57-D348BE001485@microsoft.com...
| Quote: | Hi Peoples,
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.
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.
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in