I've installed Windows Search Service (Windows Search 4.0) on SBS Server 2008.

I am trying to locate a script that would access the index and allow for full-text searching. Essentially, I would like to be able to type in a word or string into a searchbox, and have MS Access query the search index and return a list of files that contain the word or string.

If anyone has any insight on this, it would sure be appreciated!...

Loop not working

Ok, I've written some code that mostly works, but here's the problem: I have 3 files that come up in the query below. I want the code to insert those 3 files into the email as attachments. The code is inserting the first file 3 times, instead or inserting each of the 3 files. What am I doing wrong with my loop?

Private Sub EmailMarkedDocu ments_Click()
Dim MyDB As Database
Dim MyRS...

Help! I'm hoping that someone can point me to a VB script that will do a fairly simple task.

I have a Microsoft Access table that lists the full directory path for a number of files.

I am looking for a script that will create a new email message in Outlook that attaches each of the files listed in the table. The user will then input the recipient and subject, and can send the email from Outlook.

...