title: VBA to send Word Mail Merge
body: <p>When attempting to run this code I get an object required error. I am not sure how to resolve this. </p>
  
  <p>I am trying to run vba from excel to run mail merge in word. </p>
  
  <pre><code>Sub MailMerge()
      Set wordapp = CreateObject("word.Application")
      wordapp.documents.Open "C:\Users\me\Desktop\hello.docx", ReadOnly:=True
      wordapp.Visible = True
  
  
              With ActiveDocument.MailMerge
          .Destination = wdSendToEmail
          .SuppressBlankLines = True
          With .DataSource
              .FirstRecord = wdDefaultFirstRecord
              .LastRecord = wdDefaultLastRecord
          End With
          .Execute Pause:=False
      End With
  
  
  End Sub
  </code></pre>