I need the Macro VBA code for the below scenario
Sheet 1 of the excel will have data from column A to F. column A will have vendor number. Column B to F will contain the data related to that vendor it could be multiple lines of data.
sheet 2 will contain the vendor number in column A (Same as sheet 1) and column B will have the corresponding email address against each vendor number.
The Macro should now filter by every unique vendor number in the sheet 1 and copy the contents from column B to F for that respective vendor and paste that into the body of the New email (outlook) and pick the email address from sheet 2 and send the email automatically. similarly the same step should be repeated for every vendor number (filter + copy contents + add to email body)
Please note : the subject is going to be common for all emails + the body of the email will include a standard text which is common for all emails along with the contents it will copy from excel.
can someone share the code for this. May god bless you for your help.
Sheet 1 of the excel will have data from column A to F. column A will have vendor number. Column B to F will contain the data related to that vendor it could be multiple lines of data.
sheet 2 will contain the vendor number in column A (Same as sheet 1) and column B will have the corresponding email address against each vendor number.
The Macro should now filter by every unique vendor number in the sheet 1 and copy the contents from column B to F for that respective vendor and paste that into the body of the New email (outlook) and pick the email address from sheet 2 and send the email automatically. similarly the same step should be repeated for every vendor number (filter + copy contents + add to email body)
Please note : the subject is going to be common for all emails + the body of the email will include a standard text which is common for all emails along with the contents it will copy from excel.
can someone share the code for this. May god bless you for your help.
