Automate Mail Merge
<p>Here is the problem from my original post:</p>

<hr>

<p>I have a Word template (dotm) that has fields i would like filled in from a one-line/entry Excel file.  I have a "Rough.txt", the contents of which i would like to insert into a specific place in this same mail-merge-generated document in addition to the information from the Excel file.  </p>

<p>i would like to generate a DOC or DOCX from this scripting process that is saved in the same directory as the above-mentioned files.  I would like this to be done by clicking run on a bat file or similar type of situation that does not involve me manually opening the file and clicking the buttons every time i want to do it.  I would like it to be simpler than opening word manually and running the macro.  </p>

<p>Plus, if i can put it in an executable/"runnable" file like a bat or something similar, then i can attach a shortcut to it and run it with Cortana voice commands.  This is why i am going about it from this angle.  This would be a GEM to have.  Important here is that it runs when i tell it to, not scheduled at a certain time.  I have done this with other bats with great success.</p>

<hr>

<p>So i used a combination of what all the answers were to construct the following:</p>

<p>I have a bat file with a bunch of FART commands in it to correct many common grammar errors in a document; it's irrelevant and long, so i won't post it here.  It's called FINISH-1.bat.</p>

<p>Then i have a second BAT file, FINISH-2.bat, which contains only the following:</p>

<pre><code>"C:\Program Files\Microsoft Office 15\root\office15\winword.exe" "/mRunAllMacros" "C:\Transcription\Transcription\In Progress\NewKCJob\Transcript.docx"
</code></pre>

<p>So then I created about 20 find/replace Microsoft Word macros for styles which i will not post here since this was not relevant to the question.</p>

<p>I made two more macros in Word which are relevant to my issue.  The following completes the mail merge for my Excel file, which is exported from Jotform.</p>

<pre><code>Sub MailMergeCover()
'
' MailMergeCover Macro
'
'
ActiveDocument.MailMerge.OpenDataSource Name:= _
    "C:\Transcription\Transcription\In Progress\JotformExport.xlsx", _
    ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
    AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
    WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
    Format:=wdOpenFormatAuto, Connection:= _
    "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Transcription\Transcription\In Progress\JotformExport.xlsx;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Engine Type=37;Jet " _
    , SQLStatement:="SELECT * FROM `Submissions$`", SQLStatement1:="", _
    SubType:=wdMergeSubTypeAccess
With ActiveDocument.MailMerge
    .Destination = wdSendToNewDocument
    .SuppressBlankLines = True
    With .DataSource
        .FirstRecord = wdDefaultFirstRecord
        .LastRecord = wdDefaultLastRecord
    End With
    .Execute Pause:=False
End With
Windows("Transcript.docx [Compatibility Mode]").Activate
End Sub
</code></pre>

<p>And the following macro inserts my "Rough.Txt" document into the same transcript/Word document at the bookmark i inserted called "rough":</p>

<pre><code>Sub InsertRough()
'
' InsertRough Macro
'
'
If ActiveDocument.Bookmarks.Exists("rough") = True Then
    ActiveDocument.Bookmarks("rough").Select
    Selection.InsertFile FileName:="C:\Transcription\Transcription\In Progress\NewKCJob\Rough.txt"
Else
    MsgBox "Bookmark ""rough"" does not exist!"
End If
End Sub
</code></pre>

<p>The next step was to tie them all together in Word in a certain order so that my find/replace macros i mentioned earlier also apply to "Rough.txt":</p>

<pre><code>Sub RunAllMacros()
Call InsertRough
Call Macro1
Call Macro2
Call Macro3
Call Macro4
Call Macro5
Call Macro6
Call Macro7
Call Macro8
Call Macro9
Call Macro10
Call Macro11
Call Macro12
Call Macro13
Call Macro14
Call Macro15
Call Macro16
Call Macro17
Call Macro18
Call Macro19
Call Macro20
Call MailMergeCover
End Sub
</code></pre>

<p>The second-to-last step was to make a third bat file, FINISH.bat, which Cortana will be using, to call the two bat files:</p>

<pre><code>call "C:\Transcription\Transcription\In Progress\NewKCJob\FINISH-1.bat"
call "C:\Transcription\Transcription\In Progress\NewKCJob\FINISH-2.bat"
</code></pre>

<p>The last step was to create a shortcut to FINISH.bat in C:\Users\Username\AppData\Roaming\Microsoft\Windows\Start Menu\Programs called "Finish Job" for Cortana to index.  </p>

<p>Now, i can say, "Hey, Cortana, open finish job," and it will do this for me all automatically.  </p>

<p>i have just shaved 20 minutes to an hour off EVERY transcript i complete as i was doing many of these corrections manually.  i would like to respect and follow the rules as much as i can, so if i am not giving enough detail or doing something abnormally, let me know so i can fix it.  Again, thank you so much!!  Really, i could not have crafted this without your help.</p>