Send multiple emails to clients with certain rows

[atditiljazi]

I am a novice and I need a VBA code created to send multiple emails to all my suppliers from my order book at the same time. I would like the VBA to identify each row by a "supplier code"(column F) and send the rows as an attachment with the header row (A1). This spreadsheet also holds multiple columns for unit cost price, total price, delivery date, comments, etc. I would also like to update the spreadsheet when I receive the attachment back. This spreadsheet holds information of all my future deliveries and doing it manually takes 2 days and it's very time consuming. Any help will be very appreciated.

 

[atditiljazi]

i forgot to mention, the supplier code will have to be linked to the email address on another sheet