Find a Note Item

  • Thread starter Thread starter komobu
  • Start date Start date
K

komobu

Hi;

I wrote a program that will scan through our database and automatically
create note items in Outlook 2003. I want to do a "find" to see if the
note item already exists. If it does, I would like the note updated. If
it doesnt, it will save the note. Using the calendar items, I would use
some code like this:
myFind = myFolder.Items.Find("[Subject] = '" + "Leave: " +
ltrim(rtrim(tmplv->Name)) + ' '+dtoc(tmplv->from) + ' thru
'+dtoc(tmplv->to)+"'")
if .not. type("myFind")= 'L'
myFind.delete()
n_ci = n_ci - 1
endif

Any idea on how I can find a Note item and check for it existance?

Thanks for any help.
 
Items.Find is applicable to any folder.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Thanks Sue! My problem was that I was trying to search for the note
using [BODY] = 'Whatever" and it will only let me do that with
[Subject] = "Whatever"

Pat
 
May I ask why information is in the NOTES and the reason for creating
them in Outlook? Do your users SYNC the NOTES w/PDAs to go mobile with them?
 
Correct. Body is not supported in Find and Restrict strings.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Hi David;

Yes, we sync the notes with pdas. We have 100 employees on a 1 year
rotation. We have a 10 percent turnover every month. I am wanting to
transfer personnel information from our database and have it readily
available in notes for pdas.
 
And just how did I know that you were going to say that? I personaly
don't like Notes other than for quick stuff. Pretty much to me they're
disposable.

1) I'm assuming that using ContactItems is not an option?

2) Most PDA's have Pocket Web Browser, a WB that's stripped down, no
VBScript, no JavaScript, but still a Browser. I mention that because I
created a couple of ASP pages that generate static HTML pages that I
then sync to the PDA. There's a main page which has hyperlinks to the
detail information. If the *.HTML pages are plopped in the FILES folder
for the PDAs. I personally like this idea better than Notes if you can't
tell. If you're interested in it, I can email you the static HTML files
to get a feel for them.

3) Pocket Access and Pocket SQL Server do exist. Both allow database
files to reside on a PDA, however they do not have a user interface. The
UI has to be supplied by a 3rd party solution. I have used Sprint DB Pro
and *HIGHLY* recommend it. It is *EXTREMELY* easy to use and develop
with, plus there's a desktop version that allows you to build the Front
End on your PC as opposed to a PDA. (Assuming that your running Windows)

4) If you still want to go with notes, I would be inclined to just wipe
out all of the DB-related Notes and recreate them as opposed to trying
to figure out which ones need to modifying and finding them. I would use
the CATEGORIES property to flag the NoteItems.

David H
 
Thanks David, I would love to checkit out. You can email me at
(e-mail address removed). The only thing is, I use a Palm OS PDA without
wireless access. Basicaly I need to provide info to people when away
from my desk. The notes option is easy because I dont really write
anything. I will click a button on my app and the notes will
automatically be created and synced to my palm on the next sync.

Thanks for any help/ideas
Pat
 
But of course you would be using Palm OS. The items that I mentioned
require a Pocket PC running Windows Mobile. I'll send the *.html files
so you can see what information I'm talking about.
 
Back
Top