Search results

you can use this code: OlSecurityManager.ConnectTo OutlookApp OlSecurityManager.DisableOOMWarnings = True On Error Goto Finally '... any action with protected objects ... Finally: OlSecurityManager.DisableOOMWarnings = False

you can send change add .send instead of .display in your code, it will send the email directly. hereby the example (email with html format + auto send): Function sendEmail() Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem Set olApp = Outlook.Application...

Hi sos thank for the reply. yes im replacing some of "text" in module and macro, like find and replace in MSWORD. but im replacing it in diffrent database, without deleting the original object hmm.. can i use DAO ?

Thank jdraw, but when i see your code, thats for table... what i want is for the module and macro. i did manage to make one for table, query but not for module and macro.

Dear all, im stuck in vba for last 2 days. i want to perform editing module(s) and macro(s) from different access database(s). no progress in editing ( find/replace text ) macro, well this is my code for replacing word in module ( please see attachment ) its only works when in the same...