D
donwb
I use Win XP and Office 2003
I am using a routine to extract information from Outlook and use it in
Excel.
There are a number of lines of code to define the various Outlook elements,
then this:-
<<Set objContact = olJournalFolder.Items.Find("[ContactNames] =
""Singer""")>>
<<myItem = objContact.Display>>
which works fine, but the following gives the error:- Type Mismatch or the
value"MyDate" in the condition is not valid.
Set objDate = olJournalFolder.Items.Find("[Start] = MyDate")
(MyDate is a variable in the Format dd mm yyyy, which is the same format as
the 'Start' dates in the Outlook Journal.)
I think it must be a wrong syntax or date format, as I expected
"ContactNames" and "Start" to be treated the same in the .Find statement.
Guidance would be welcome
donwb
I am using a routine to extract information from Outlook and use it in
Excel.
There are a number of lines of code to define the various Outlook elements,
then this:-
<<Set objContact = olJournalFolder.Items.Find("[ContactNames] =
""Singer""")>>
<<myItem = objContact.Display>>
which works fine, but the following gives the error:- Type Mismatch or the
value"MyDate" in the condition is not valid.
Set objDate = olJournalFolder.Items.Find("[Start] = MyDate")
(MyDate is a variable in the Format dd mm yyyy, which is the same format as
the 'Start' dates in the Outlook Journal.)
I think it must be a wrong syntax or date format, as I expected
"ContactNames" and "Start" to be treated the same in the .Find statement.
Guidance would be welcome
donwb