I have a data in Column A with a Title BUYER and all the buyers names listed below.
Listed adjacent to this in Column B I have the EMAIL addressess of each buyer
Currently I have a macro that upon running it filters the records by the BUYERS names one by one and automatically prints each of them in seperate sheets.
I would like to know if I could have also written in it a code to email the records to each buyer filtered as a seperate workbook.
Though the buyers name is repeated in number of lines depending on the number of records, the adjacent column too would contain a repeated equal amount of email ids, however a single email needs to be sent containing the rows on a seperate workbook filtered according to the buyers name and then proceed to the records of the next buyer to do the similar action.
My email client is Outlook 2003.
Appreciate for your help.
Chrisham
Listed adjacent to this in Column B I have the EMAIL addressess of each buyer
Currently I have a macro that upon running it filters the records by the BUYERS names one by one and automatically prints each of them in seperate sheets.
I would like to know if I could have also written in it a code to email the records to each buyer filtered as a seperate workbook.
Though the buyers name is repeated in number of lines depending on the number of records, the adjacent column too would contain a repeated equal amount of email ids, however a single email needs to be sent containing the rows on a seperate workbook filtered according to the buyers name and then proceed to the records of the next buyer to do the similar action.
My email client is Outlook 2003.
Appreciate for your help.
Chrisham