title: Mailmerge from Excel using Word template VBA
body: <p>I have created a Userform where you can flag records as "In Progress", "Completed", and "Not Completed".</p>
  
  <p>This will reflect on the sheet as below:</p>
  
  <p>Records marked as "In Progress" will have the letter "P" in the status column.
  Records marked as "Completed" will have the letter "Y" in the status column.
  Records marked as "Not Completed" will have the letter "N" in the status column.</p>
  
  <p><a href="http://im39.gulfup.com/VZVxr.png" rel="nofollow noreferrer">DataSheet http://im39.gulfup.com/VZVxr.png</a>!</p>
  
  <p>I want to run a mailmerge using the below buttons on the user form:</p>
  
  <p><a href="http://im39.gulfup.com/98isU.png" rel="nofollow noreferrer">Userform http://im39.gulfup.com/98isU.png</a>!</p>
  
  <p>I have created this work template for the fields.</p>
  
  <p><a href="http://im39.gulfup.com/4WMLh.png" rel="nofollow noreferrer">Document http://im39.gulfup.com/4WMLh.png</a>!</p>
  
  <p>This word template file called "MyTemplate" will be in the same directory as the excel file.</p>
  
  <p>I am trying to figure out how:
  (1) Select recepients by filtering the "Status" column, so if the user pressed the first button, it will run the mail merge only for records with "P" in the status column.</p>
  
  <p>(2) Run mailmerge without displaying Microsoft Word and only displaying the "Save As" dialog where the user can select where to save the file.</p>
  
  <p>(3) This file should be saved in PDF format.</p>
  
  <p>I am running Office 2013 and so far I have the code in bits and pieces and had no luck when trying to run it. 
  I have uploaded the data I am trying to work on:
  MyBook: <a href="https://db.tt/0rLUZGC0" rel="nofollow noreferrer">https://db.tt/0rLUZGC0</a>
  MyTemplate: <a href="https://db.tt/qPuoZ0D6" rel="nofollow noreferrer">https://db.tt/qPuoZ0D6</a></p>
  
  <p>Any help will be highly appreciated.
  Thanks.</p>