title: Script is not showing any error but still not able to send email via python
body: <p>i am simply trying to send an email to someone whatever is stored in dataframe and when i run the script it ends with process finished with exit code 0 but i see nothing in my sent items.Earlier it was working fine not sure what has gotten into it.</p>
  <pre><code>import pandas as pd
  from sqlalchemy.engine import create_engine
  import datetime
  from plyer import notification
  import win32com.client as win32
  
  
  
  today = datetime.date.today()
  
  
  df = pd.read_sql(sql = query, con = engine)
  
  
  if df.shape[0] == 0:
      print('No result!!!')
  
  else:
       olApp = win32.Dispatch('outlook.application')
       #olNS = olApp.GetNameSpace('MAPI')
       mailItem = olApp.CreateItem(0)
       Body ='''\
       &lt;html&gt;
         &lt;head&gt;&lt;/head&gt;
         &lt;body&gt;
              &lt;p&gt;Please find below the setups for the day.&lt;br&gt;
              &lt;body&gt;''' + df.to_html() + '''&lt;/br&gt;&lt;/body&gt;  
              &lt;font color = &quot;blue&quot;&gt;
              &lt;br&gt;Thanks&lt;/br&gt;
              &lt;/font&gt; 
              &lt;br&gt;&lt;/br&gt;
              &lt;br&gt;&lt;/br&gt;
              &lt;br&gt;&lt;/br&gt;
              &lt;font color=&quot;black&quot;&gt;
              Please note this is an automated mail&lt;t1&gt;
              &lt;/font&gt;
         &lt;/p&gt;
         &lt;/body&gt;
         &lt;/style&gt;
         &lt;/html&gt;'''
  
       mailItem.Subject = &quot;Setup report: &quot; + &quot; &quot; + str(today.strftime('%d-%b-%y'))
       mailItem.To = 'varunadhawan@xyz.com'
       abhinit.Kumar@ihsmarkit.com'
       mailItem.HTMLBody = Body
       From = 'daviddhawan@xyz.com'
       mailItem.Send
  </code></pre>