excel - Is there a way to prevent autoresolve in outlook? -
i sending email automating outlook excel , have managed bypass pesky warning message viruses using sendkeys (with inspector activate prior call sendkeys).
now message allowing access contacts. have email addresses recipients , don't need access contacts, outlook autoresolve kicks in , pop allowing access contacts appears. doesn't have 5 second delay, still prevents system being automated. i'm trying avoid using 3rd party tools redemption , wondering if has found way turn autoresolve off.
i've read posts on other sites suggesting turning off autocomplete , automatic name checking, outlook still attempts resolve address when mail sent.
any pointers gladly received.
edit 24/08/13
i have heard if outlook 2007 , above , correctly installed system microsoft approved virus scanner not see message, don't have control on installation of programs on users machines.
the code have tried includes
function mailit(byval smessageto string, byval ssamplercenter string, byval sfilespec string) dim olapp outlook.application dim objmail outlook.mailitem dim blnolopen boolean on error resume next set olapp = getobject(, "outlook.application") blnolopen = true on error goto 0 if olapp nothing set olapp = createobject("outlook.application") blnolopen = false end if set objmail = olapp.createitem(olmailitem) objmail .to = smessageto .subject = ssamplecenter .attachments.add sfilespec .send end
this causes warning message viruses , causes 5 second wait before user can choose send mail. sendkeys method use same with objmail
following:
dim myinspector outlook.inspector objmail .to = messageto .subject = samplecenter .attachments.add filespec .display end set myinspector = objmail.getinspector myinspector.activate sendkeys "%s", true
i have code checking number of items in sent folder has increased , waiting/calling inspector , sendkeys function if hasn't. method doesn't lead warning, results in dialog box asking if user wishes allow access contacts.
in outlook: go options -> e-mail , disable checkbox "resolve names automatically".
Comments
Post a Comment