title: I want to learn how to convert a string using access 2010 vba
body: <p>I want to go from this type string </p>
  
  <pre><code>4567 0212 11 4567 0212 12 4567 0212 13 4567 0212 14 4567 0212 15
  </code></pre>
  
  <p>to one that looks like this </p>
  
  <pre><code>4567 0212 11, 4567 0212 12, 4567 0212 13, 4567 0212 14 and 4567 0212 15
  </code></pre>
  
  <p>This will be used in an automated outlook message, so the length will change with the number of records I am pulling.</p>