Macro to email row/header from spreadsheet

[kariw]

I'm trying to figure out how to email the contents of a row (including the header, if possible) to an email address specified in that row. I've attached a sample spreadsheet that shows the type of info I have.
The columns are just the customer #, quantities of different items, and the subject/body of the email (which will be the same for all emails sent each week).
The email doesn't have to be anything fancy. Just a simple subject and message (if possible) then the item #'s and quantities they'll receive.
Thanks so much in advance for any help!

[Logit]

.

Please Login or Register  to view this content.

[dangelor]

Try...

Please Login or Register  to view this content.