Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Formula help? - instr

0 views
Skip to first unread message

Syme

unread,
Feb 28, 2007, 6:59:02 PM2/28/07
to
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

Sue Mosher [MVP-Outlook]

unread,
Mar 23, 2007, 8:44:06 AM3/23/07
to
THis is a formula for use where? In what version of Outlook?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Syme" <Sy...@discussions.microsoft.com> wrote in message news:52FAFEB8-8852-422E...@microsoft.com...

GS

unread,
Mar 30, 2007, 4:18:00 PM3/30/07
to
wonder if the OP is talking about some vba code
"Sue Mosher [MVP-Outlook]" <sue...@outlookcode.com> wrote in message
news:eTnGvyUb...@TK2MSFTNGP03.phx.gbl...
0 new messages