I have 4 columns. Email address, Name, Date and Qty. (I have many more,
but 4 will suffice for my scenario.)

Is there someway to send an email to the email address listed in cell A2,
that in the body of the email will contain the values listed in B2:D2 ?

example:

Hello [B2]. We recieved your request for [D2] widgets. Someone will
contact you on [C2] to discuss further.