i am looking to send order confirmations to my clients via email based on data I type into my master worksheet.

i will type in all orders we receive on day 1, from all different clients (A, B and C) with the relevant details to confirm the order.

i want a method to send email so that each client receives his own individual confirmation from my master worksheet.

is this possible? please advise.

thanks for your help.