Recent content by gchichester

If .Display is stopping the application, what does is .Send doing?

NauticalGent, I did the google search for redemption as you suggested, What I found seemed to be a low level programming solution. To me if it's that deep in the security setting why does the code work using .display?

NauticalGent, I checked all my security setting thinking it my be the issue, Then I realized I'm using the same code from the same project to send other email with out the error. I compared both sub and didn't see any issues. It's error is a real mystery,

Thanks to both for your thoughts, Sorry I should have posted more of the code, and the real reason for using Shell. It was workaround I needed because I couldn't find a solution for the sub failing at the .send but works fine if i use .Display It fails and returns a run-time 287 Option Compare...

I trying to open Outlook Minimized, before running a subroutine, then close it when sub completes. This code opens Outlook but doesn't minimize it. Sub StartOrdProcess() '/ Run the Daily Orders .csv Import Shell "C:\Program Files (x86)\Microsoft Office\Office14\outlook.exe", vbMinimizedFocus...

That helps! Thanks for your input, Gilc

That was just to simple! I thing I will remember this one. Thank you Gilc

I can't figure out why I keep getting a "type mismatch" error when this SQL statement runs from my form. I have this same statement as a query and it runs correctly. Data type for the "UsedBookingNumbers" fields are Text. Users may not have a booking number at the time of entry so they add a " -...