excel VBA to Automatically select Yes when prompted during mail merge -

-

i'd system automated users possible. right now, have code runs when user clicks button. code takes data intention of applying word document via mail merge.

everything works intended except there's message pops saying

opening document run following sql command:

select * 'tags$'

data database placed in document. want continue?

i need keep simple possible without risking users selecting "no" because they're confused. how can vba automatically proceed , accept data placement, had selected "yes"?

i tried using following code block alerts in hopes default "yes" , proceed, didn't work.

application.displayalerts = false

this have

sub runmailmerge()      application.screenupdating = false      dim wdoutputname, wdinputname string     wdoutputname = thisworkbook.path & "\nametags - " _         & format(date, "d mmm yyyy")     wdinputname = thisworkbook.path & "\nametags.docx"      ' open mail merge layout file     dim wddoc object     set wddoc = getobject(wdinputname, "word.document")     wddoc.application.visible = true      wddoc.mailmerge          .maindocumenttype = wdformletters          .destination = wdsendtonewdocument          .suppressblanklines = true          .execute pause:=false     end      'application.screenupdating = true      'show , save output file     wddoc.application.visible = true     wddoc.application.activedocument.saveas wdoutputname      ' cleanup     wddoc.close savechanges:=false     'activedoc.close     set wddoc = nothing  end sub

try setting displayalerts property in word (if that's alert coming from):

dim tmp long  tmp = wddoc.application.displayalerts   wddoc.application.displayalerts = wdalertsnone 'do action causes prompt wddoc.application.displayalerts = tmp

Comments

Post a Comment

Popular posts from this blog

c# - SVN Error : "svnadmin: E205000: Too many arguments" -

-
i trying reposotries using c# code process svncommand = null; var psi = new processstartinfo("svnadmin"); psi.redirectstandardoutput = true; psi.redirectstandarderror = true; psi.useshellexecute = false; psi.arguments= @"dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump"; using (svncommand = process.start(psi)) { var myoutput = svncommand.standardoutput; var myerror = svncommand.standarderror; debug.write("output :" + environment.newline + environment.newline + myoutput.readtoend() + environment.newline + "error :" + environment.newline + environment.newline + myerror.readtoend()); svncommand.close(); } when use dump command commandline svnadmin dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump it works fine when try ...
Read more

c# - Copy ObservableCollection to another ObservableCollection -

-
how copy observablecollection item observablecollection without reference of first collection? here observablecollection item value changes affecting both collections. code private observablecollection<ratemodel> _allmetalrate = new observablecollection<ratemodel>(); private observablecollection<ratemodel> _metalrateondate = new observablecollection<ratemodel>(); public observablecollection<ratemodel> allmetalrate { { return this._allmetalrate; } set { this._allmetalrate = value; notifypropertychanged("metalrate"); } } public observablecollection<ratemodel> metalrateondate { { return this._metalrateondate; } set { this._metalrateondate = value; notifypropertychanged("metalrateondate"); } } foreach (var item in metalrateondate) allmetalrate.add(item); what causing , how can solve it? you need clone object referenced item before it's a...
Read more

All overlapping substrings matching a java regex -

-
is there api method returns (possibly overlapping) substrings match regular expression? for example, have text string: string t = 04/31 412-555-1235; , , have pattern: pattern p = new pattern("\\d\\d+"); matches strings of 2 or more characters. the matches are: 04, 31, 412, 555, 1235. how overlapping matches? i want code return: 04, 31, 41, 412, 12, 55, 555, 55, 12, 123, 1235, 23, 235, 35. theoretically should possible -- there obvious o(n^2) algorithm enumerates , checks substrings against pattern. edit rather enumerating substrings, safer use region(int start, int end) method in matcher . checking pattern against separate, extracted substring might change result of match (e.g. if there non-capturing group or word boundary check @ start/end of pattern). edit 2 actually, it's unclear whether region() expect zero-width matches. specification vague, , experiments yield disappointing results. for example: string line = "xx90xx"; strin...
Read more