Sending a template email with dynamic content from excel

Hello all,

I am struggling to get the VBA to do what I want and I am running out of ideas, I would really appreciate it if someone could help me.

I have inserted a command button into an excel document that once pressed, opens an email in outlook and adds all of the key data to the subject line and the body of the text.
At the moment I am only able to add the standard text to the email but what I want to do is add some figures/dates/etc. at certain points in the text (I have emboldened these as an example below).
These will be fed from cells on another page in the same documents.



olMail.Body = "Good Morning" & vbNewLine & vbNewLine & _
"Thank you for your purchase order to the total value of AUTOADDVALUE which we received on AUTOINPUTDATE, in which you refer to a delivery date of AUTOINPUTDATE." & vbNewLine & _



Thank you for any help that you can give.
Kind Regards,
Neil