title: Open mail template in excel via vba and fill template with excel data
body: <p>I need some help using excel for filling a mail template.
  My problem right now is how to open the template with a macro 
  I wrote this:</p>
  
  <pre><code>Sub OpenMail()
  
      Open "L:\Projekte\Abteilung\Projekt\Vorlage_deutsch" For Input As #1
  
  End Sub
  </code></pre>
  
  <p>Running this macro it throws me an error that says data can not be found.
  Is there a way to save the template in excel directly instead of trying to open it from the computer?
  Also if you have any idea on how to fill the email with the data of my rows in excel that would be really helpful! 
  Thanks!!</p>