Variable Mail Merge to Email from Excel
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?
Last edited by Cib886; 01-06-2020 at 07:45 PM.
Reason: Missed some information
|