• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA to copy header row and post in email, excel 2010

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.
 

Attachments

Back
Top