ASP.NET, SQL Server, WPF, C#, VB.NET

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.=20  
  
--=20  
  
Sue Mosher, Outlook MVP  
  
Author of Configuring Microsoft Outlook 2003  
  
http://www.turtleflock.com/olconfig/index.htm  
  
and Microsoft Outlook Programming - Jumpstart for=20  
  
Administrators, Power Users, and Developers  
  
http://www.outlookcode.com/jumpstart.aspx  
  
"komobu" <curranpg@gmail.com> wrote in message =  
  
news:1128038776.813395.4340@g47g2000cwa.googlegroups.com...  
  
automatically  
  
If  
  
use

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?  
  
komobu wrote:

Correct. Body is not supported in Find and Restrict strings.=20  
  
--=20  
  
Sue Mosher, Outlook MVP  
  
Author of Configuring Microsoft Outlook 2003  
  
http://www.turtleflock.com/olconfig/index.htm  
  
and Microsoft Outlook Programming - Jumpstart for=20  
  
Administrators, Power Users, and Developers  
  
http://www.outlookcode.com/jumpstart.aspx  
  
"komobu" <curranpg@gmail.com> wrote in message =  
  
news:1128080033.902318.26380@z14g2000cwz.googlegroups.com...

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  
  
komobu wrote:

Thanks David, I would love to checkit out. You can email me at  
  
curranpg@gmail.com. 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.  
  
komobu wrote: