Attached are two workbooks.
Work book one contains a spreadsheet with a number of rows containing supplier terms.
You will also see a button "press to send terms to suppliers" - This button will collate all the rows where the email address in column T are the same (and the column headings) and will send a separate workbook to the appropriate email address. PLEASE TEST
I would like to assign the same macro to workbook 2 only with the following differences......
1. Only send columns in the range A:W - do not include any columns after this.
2. Change it so it sends to the email address in column W
3. Do not collate and send rows where column X contains (RESOLVED) or column Y contains (INTERNAL QUERY)