Recent content by Deke

Okay figured it out. Wow was I overthinking it. Okay My next step is getting the .msg file imported into the correct record in the db table. Does anyone have any resources for this? I'll be researching how to do this shortly but figured I'd ask anyway. Thanks again for the help!

I'm getting a lot of compile errors when I attempt this. Either I'm getting Argument not optional or procedure declaration does not match description of event or procedure of the same name. I'm guessing it has to do with the attempt to use the Application_NewMailEx in order to identify new...

I was hoping there would be an easy way to just use insert into to insert an object (MyMail) as an attachment. But it looks, based on what you're saying, I'll need to save the incoming email as a file on the HD and then from there import it into the correct record on the table using the ID...

Okay so in testing getting a type mismatch? should I be using a different DIM definition?

Yeah I understand it probably will at some point but I am putting in some filtering in the code because only a specific email type will be added to the table. Appreciate the warning though.

Gotcha! I will give this a test. Also is my syntax right for my insert into line? I know I was playing around with it at one point and getting some strange syntax errors. Once I give this a try I'll see if they pop up.

Hi All, I've setup a simple process in Outlook VBA when an email comes in it will grab the Sender, Subject, Body and received time from the email and dump it into a table (ITtbl) in Access. The problem I'm having is, I also want to attach the entire email in the access table. I've setup an...

I haven't. Trying to think how that would work for my application. I wrote this so it would just validate what my users enter before a final submission. Let me look this up and see if I can make that work. If you have any suggestion on how I could make that work for what I'm trying to do I'd...

Hi All, I'm trying to write a function that looks at two record sets and verify that pack numbers match between RetailEntry and tblTemp. If a pack number is in RetailEntry and not tblTemp then I want it give a warning. What I have below works for a 1 to 1 check BUT there is the possibility of...

this is exactly what I was looking for! Thank you soo much! Also want to thank everyone who responded you helped me out more than you know and I learned a lot! really greatly appreciate the time you all took and the info you provided. I'll do my best to share what I learn!

wow this is a lot to go through.... Thanks! I'll take a look and see where I come out with this.

Thanks for the response. Doesn't seem to work If I use it for an If statement it doesn't seem to recognize that anything is checked.

Could you be more specific? On which part? The whole thing or only one section of my code?

Hi All, New here! Hoping someone can help me. I'm self taught in VBA and this issue has stumped me. I have a table "tblMtemp" there is a column for "PackNum" What I'm trying to do is right some code that verifies that for "PackNum" there is at least one Checkbox checked. In this example...