steve400243
Member
Hello, On the attached sample worksheet when Column A changes to Delivered it creates an email to send to the name selected in Column Q. It copy's the selected row (Column A - F) and pastes in the body of the email. I need to get row 1 - A thru F to copy and paste above the row in each email. Hope this is able to be done. Thank you for all help.