I am wanting to send an order confirmation email to our customers but it needs to have specific customer and order details in it.


below is a sample of what i need



Dear customer,


Your order has been processed, half your order will be dispatched from warehouse 1 and the other half from warehouse 2, please see details below,


Invoice 000001 will be shipped for warehouse 1 and contains the below item,


12584 black shoes
36548 white shirt
69745 white socks


Invoice 000002 will be shipped for warehouse 2 and contains the below item,


15789 white shoes
36558 Black shirt




the reds parts are what is pulled from Excel.


Problems i am having with this are

- all orders will differ in size and items.
- i can only get it to put the invoice number before each item
- i am unable to add an email signature as all orders differ in size


can anyone please help with this?