danovkos
07-01-2009, 02:34 AM
hi all
pls. how can i do folowing?
I have huge wb (about 60 000 rows and 20 columns).
There is an autofilter.
I want to use some filters and after fitering i need to send one email to all filtered persons, whos are on the end of the filtered rows (mostly maximum 20 rows). Only one name is at the end of row. Mail will contains only filtered rows (doesnt matter if it will as atachment in WB or only pasted rows in mails).
I know how i write the code to filtering what i want, and how can i add the names at the end, but i don know, how to continue.
There is no complete adress at the end of rows. And i need following my definition assignt to each name equivalent mail adress and then get all adress together to field „to:“ Maximum it will be 6 persons.
Definition how are assigned name to mail adress:
Daniel get adress dan@domain.com
Dido is dany@domain.com
Johny is john@domain.com
Joey is joe@domain.com
To subject i need add a text „report“, to body i need to add text "Here is a daily report" and prepair to sending.
Thank you for your help.
pls. how can i do folowing?
I have huge wb (about 60 000 rows and 20 columns).
There is an autofilter.
I want to use some filters and after fitering i need to send one email to all filtered persons, whos are on the end of the filtered rows (mostly maximum 20 rows). Only one name is at the end of row. Mail will contains only filtered rows (doesnt matter if it will as atachment in WB or only pasted rows in mails).
I know how i write the code to filtering what i want, and how can i add the names at the end, but i don know, how to continue.
There is no complete adress at the end of rows. And i need following my definition assignt to each name equivalent mail adress and then get all adress together to field „to:“ Maximum it will be 6 persons.
Definition how are assigned name to mail adress:
Daniel get adress dan@domain.com
Dido is dany@domain.com
Johny is john@domain.com
Joey is joe@domain.com
To subject i need add a text „report“, to body i need to add text "Here is a daily report" and prepair to sending.
Thank you for your help.