Hi,

A b c d
Custmer Name Customer Email Id Order No Shipment tracking No
abc abc@gmail.com 123 456
xyz xyz@ymail.com 789 345


I do have this data in excel file,
I wanted a Macro from which i can send direct mail via outlook,

mail should be,

Dear abc,

Your order no. 123, has been dispatch by shipment no. 456.

Thanks


Please help me to do this.