Good morning,
The built-in Rules wizard in Outlook doesn't look for differences between
upper/lower case letters. So I'm trying to create VBA codes that will look
at a subject of an email and compare it to what it should be. I'm trying to
use the exact function, because I'm familiar with that in Excel. But in
Outlook I'm getting an error.

Code:

if Exact(Text)="THIS is THE Text" then
' do something
end if

It would be simply:

if Text="THIS is THE Text" then

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



"Ron_D" wrote:

Good morning,
The built-in Rules wizard in Outlook doesn't look for differences between
upper/lower case letters. So I'm trying to create VBA codes that will look
at a subject of an email and compare it to what it should be. I'm trying to
use the exact function, because I'm familiar with that in Excel. But in
Outlook I'm getting an error.

Code:

if Exact(Text)="THIS is THE Text" then
' do something
end if

Thank you, Sue, for all your help!!! That did the trick.

"Sue Mosher [MVP-Outlook]" wrote:

It would be simply:

if Text="THIS is THE Text" then

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



"Ron_D" wrote:

Good morning,
The built-in Rules wizard in Outlook doesn't look for differences between
upper/lower case letters. So I'm trying to create VBA codes that will look
at a subject of an email and compare it to what it should be. I'm trying to
use the exact function, because I'm familiar with that in Excel. But in
Outlook I'm getting an error.

Code:

if Exact(Text)="THIS is THE Text" then
' do something
end if