excel - ActiveX Component can't create object for Outlook VBA -


i trying run macro send email via outlook.

my code looks this:

sub mail_small_text_outlook() 'for tips see: http://www.rondebruin.nl/win/winmail/outlook/tips.htm 'working in office 2000-2013     dim outapp object     dim outmail object     dim strbody string      set outapp = createobject("outlook.application")     set outmail = outapp.createitem(0)      strbody = "hi there" & vbnewline & vbnewline & _               "this line 1" & vbnewline & _               "this line 2" & vbnewline & _               "this line 3" & vbnewline & _               "this line 4"      on error resume next     outmail         .to = "ron@debruin.nl"         .cc = ""         .bcc = ""         .subject = "this subject line"         .body = strbody         'you can add file         '.attachments.add ("c:\test.txt")         .send   'or use .display     end     on error goto 0      set outmail = nothing     set outapp = nothing end sub

at line: set outapp = createobject("outlook.application"), gives error:

runtime error '429': activex component can't create object.

i ran line in cmd:

regsvr32 /i "c:\windows\system32\outlvba.dll".

then gives me error:

the module "c:\windows\system32\outlvba.dll" failed load. make sure binary stored @ specified path or debug check problems binary or dependent .dll files. specified module not found.

need guidance on this.

do have click2run edition of office installed on problematic pc?

the click2run edition of office 2010 doesn't support automation. see office 2010 click-to-run compatibility add-ins more information. may find how to: verify whether outlook click-to-run application on computer article.

see you receive run-time error 429 when automate office applications more information.


Comments

Post a Comment

Popular posts from this blog

javascript - Google App Script ContentService downloadAsFile not working -

i have web app developed using google app script htmlservice , html form, populating excel sheet in google drive using spreadsheetapp . , 1 section calling contentservice download data excel file. function doget(e) { // read excel sheet //getappfile(); // render application html template return htmlservice.createtemplatefromfile('index').evaluate() .settitle('go smart') .setsandboxmode(htmlservice.sandboxmode.iframe); } function downloaddoublequatecsvfile() { var sheetid = propertiesservice.getscriptproperties().getproperty('sheetid'); var ss = spreadsheetapp.openbyid(sheetid).getactivesheet(); //var ss = spreadsheetapp.getactivespreadsheet().getactivesheet(); var maxcolumn = ss.getlastcolumn(); var maxrow = ss.getlastrow(); var data = ss.getrange(1, 1, maxrow, maxcolumn).getvalues(); if (data.length > 1) { var csv = ""; (var row = 0; row < data.length; row++) { (var c...
Read more

javascript - Function overwritting -

is there way overwrite function or event handling in function? using addeventlistener, can have many event handlers on element want var test=document.getelementbyid("div"); test.addeventlistener("click",function(){alert("im first");},false); test.addeventlistener("click",function(){alert("im second");},false); // alerts "im first" , after "im second" but if want overwrite function/event example based on client width example this function one() { alert("first"); } function two() { alert("second"); } window.onresize = function() { var test = document.getelementbyid("div"); if (window.innerwidth > 500) { test.onclick = 1 } else { test.onclick = two; } } is possible in javascript? in case use effective little known approach. addeventlistener can accept object property handleevent event handler. in case it's easy overwr...
Read more

php - Find a regex to take part of Email -

i have following emails need extract part from: bestellnummer xxx: 1 von xxx, 1er pack ------------- anfang der nachricht ------------- foo bar baz foo bar baz // <<<<< need text here ------------- ende der nachricht ------------- ------------- anfang der nachricht ------------- foo bar baz foo bar baz ------------- ende der nachricht ------------- there 0 unlimited occurences of ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- and i'm able extract first part regex: $re = "/------------- .*? -------------.?(.*?).?------------- .*? -------------/s"; but, i'm quite new on learning regex, i'm pretty sure there must better regex extract part (foo bar baz foo bar baz) of text between ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- as can in different languages, i'm using .? to match between hyphens. i...
Read more