Search results

can you expand on this please? Currently I'm using sendobject and was about to use the code in my first post to avoid the prompts. I'm still using 2007 also, thanks.

it would be nice to find FREE outlook vba to click yes for instances of mail merges from word.

I ended up rewritting EVERYTHING, :( I was previously tring to fix something that was overly complicated :eek: to nail so I didn't want to rewrite, I just wanted the code to execute as the logic didn't have a problem. My problem was that within a do while not rs.eof, I moved around the...

its been a pain for me to click through yes for every email sent through outlook. apparently this page has the vba you can use to disable it and just wanted to share. http://www.everythingaccess.com/tutorials.asp?ID=Outlook-Send-E-mail-Without-Security-Warning

I built an app that compares the next record with the current. The way I did it was storing current values into variables then .movenext and compare. then moving back before progressing through the rest of the code that takes into consideration whether certain data between the current and the...

nevermind , I got it

what can possibly be wrong with this, it follows the form of a code sample. tbltemp is from select statement in original post. rs.Open "select * from tbltemp , , adOpenDynamic, adLockOptimistic" I get run-time error '-2147217900 (80040e14)': in from clause

got past that line,,, thanks!

its a yes/no

hello forum. I get a runtime error 3464 data type mismatch in criteria expression when doing this sql: mysql = "SELECT tblLoads.Ref, tblloads.contents, tblloads.[destination port], tblLoads.Carriers, tblLoads.[Ship Date], tblLoads.[Est Arrival], tblLoads.Brokers, tblBrokers.[ISF email]...