![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
Using the Find method to find a Subject, I have a couple of questions.
If the Subject is "Test", the following code finds the email. If the subject is " Test", it does not. I have to remove the prefix. Why is that? If the subject is null, my code doesn't find the email. I figure someone can send an email without a subject. Any idea on correcting it? If Not IsNull(strSubject) Then Set objMail = _ objNS.GetDefaultFolder(6).Items.Find("[Subject] = """ & _ strSubject & """") Else Set objMail = _ objNS.GetDefaultFolder(6).Items.Find("[Subject] Is Null") End If I have a question on finding the email by date as well. I pass a date field to the function. It converts the date time to a string then searches. Out of 10 email times passed to it, if found only 1. Any idea whay the code below fails the majority of the time? strTime = Format(datTime, "m/d/yyyy h:nn AMPM") Set objMail = objNS.GetDefaultFolder(6).Items.Find("[ReceivedTime]= """ & strTime & """") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Question on getExchangeUser method in Outlook Add-in | paresh | Outlook and VBA | 3 | October 13th 09 08:05 PM |
question about AddStore method | [email protected] | Outlook and VBA | 2 | November 27th 07 06:53 PM |
Find Method and Private Meetings | Tadwick | Outlook and VBA | 6 | August 28th 07 04:56 PM |
Outlook find Method | Meex | Outlook and VBA | 4 | May 4th 07 07:25 AM |
MailItem.SaveAs method | Mrunali | Outlook - Using Forms | 0 | April 17th 07 03:16 PM |