G
Guest
The part of the formula that is currently failing is this:
instr(1,[Message],"Instance ID:",1)
It's supposed to return the postion of the string "Instance ID:".
It does work for all messages received, but if the message has been replied
to it doesn't seem to find the occurence of "Instance ID:" in the body of the
original message.
eg. using instr function on the message below does not find the string ..
Subject: RE: blah blah
Message:
Hi,
blah blah blah
Regards,
Me
-----Original Message-----
From: someone
Sent: Wednesday, 17 May 2006 8:33 AM
To: someoneelse
Subject: blah blah
Instance ID: 12345678
instr(1,[Message],"Instance ID:",1)
It's supposed to return the postion of the string "Instance ID:".
It does work for all messages received, but if the message has been replied
to it doesn't seem to find the occurence of "Instance ID:" in the body of the
original message.
eg. using instr function on the message below does not find the string ..
Subject: RE: blah blah
Message:
Hi,
blah blah blah
Regards,
Me
-----Original Message-----
From: someone
Sent: Wednesday, 17 May 2006 8:33 AM
To: someoneelse
Subject: blah blah
Instance ID: 12345678