Recent content by jamie57

Hmm, solved the problem. Used "" instead of ' , and it seems to work now.

I am trying to restrict Outlook sent items to a certain Name or email address. Can someone tell me why this restrict command does not return any results, and what I have to do to get it working? Set olApp = New Outlook.Application Set nsNameSpace = olApp.GetNamespace("MAPI") Set fldFolder =...

Thank You! Yeah, that works good. Now, another question... I am going to be doing this for both the Inbox and Sent Items, which I can get working. But, we have changed how we are going to do this now, instead of using the time/date stamp, we are just going to Restrict by an email address...

Hmm, let me explain what I am trying to do. We are creating a contact management type database. We are going to use outlook features for sending and receiving messages, so when a message is sent we would like to keep some info on it in the database so that when we go to that client's record...

Hmmm... well, thats not exactly what I wanted, I actually wanted it the other way around... I think i missed a few words in my explanation... I want the outlook new message brought up and then when the message is sent, that the outlook entryid and/or date stamp returned to the access...

Is there any way to have a value such as the EntryID, or even a the date/time stamp (SentOn) when sending email by bringing up the outlook new message window? Currently I thought of two ways to send email: DoCmd.SendObject acSendNoObject or Dim outobj As Outlook.Application Dim outmail As...

I forgot to ask why can I not use the .Find or .Restrict in this case? Does it not allow these fields? What does it allow? Thanks.

Thanks, yeah I guess we will have to use the If statement.. I just tried it with an inbox with 1000 messages and it took about 45 seconds... Oh well, I guess we will have to deal with it. On the other note, I found out why I was getting the error before. There was an appointment that wasn't...

Yes, Thank you, the date stamp will probably work fine, I've tried this code on my dblclick for the listbox with no success: Dim olApp As Outlook.Application Dim nsNameSpace As Outlook.NameSpace Dim fldFolder As Outlook.MAPIFolder Dim objMessages As Outlook.Items Dim objMessage As...

Yeah I changed to Subject and its the same problem. So I put the On Error Resume Next and it all seems to work fine. Thanks! On another note, is there some kind of unique key for each message? So once the list box it populated we can add an onclick event to do a objMessage.Display based on...

Actually, I just noticed its not just getting the first message, its getting a bunch, and then its giving the mismatch error... and the error is at the Next objMessage. I did the mouse over to check the objMessage.To, and it shows as object variable or with not set, so maybe I will have to use...

Thank You! That looks like it will work, but when it gets to the Next objMessage, its now giving a "Type Mismatch Error". So I am only getting the first message... Any ideas?

I am trying to populate a listbox with data from an outlook sent items folder, the code is as follows: Dim olApp As Outlook.Application Dim nsNameSpace As Outlook.NameSpace Dim fldFolder As Outlook.MAPIFolder Dim objMessages As Object Dim strData As String Set olApp = New Outlook.Application...

Thank You. I am new to using VB in Access, though I have a lot of experience with VB outside of access. How do I use the string strSQL as the query for a listbox?

We have a SQL back end, and an Access data project as the front end. We have a form that displays customer info from a customer table, then we are trying to have a list box with data from another table but ONLY the data that corresponds to that CustomerID. CustomerID is in both tables and...