title: How to copy a number with comma as thousands separator from a cell to an email?
body: <p>I have an Outlook macro that will reply to the currently selected email within Outlook, asks the user for input and then based on the input it will fill the email with specific information in an Excel workbook (xl).</p>
  <p>I'm using <code>cost = xl.WorksheetFunction.VLookup(varInput, ws.Range(&quot;A:G&quot;), 5, False)</code> to look for a value/number based on the user's input and then using the value <code>cost</code> in the body of the email. The body is structured with .HTMLBody</p>
  <p>I need <code>cost</code> to be formatted as number with commas as the thousands separator (3,564). I tried:</p>
  <pre><code>cost = xl.WorksheetFunction.VLookup(varInput, ws.Range(&quot;A:G&quot;), 5, False)
  cost_format = Format(cost , &quot;#,##0&quot;)
  </code></pre>
  <p>and then using <code>cost_format</code> in the body of the email, but this gives me number with space as the thousands separator (3 564).</p>