Sending auto mail using filter

[jimsenthil]

Dear Team,
support required on auto mailing the current sheet with the below condtion

1 list , sheet need be filtered 1 by one individually and moved to separatee sheet, based on the sale's personal names (Column D)

2 and the moved Sheet need to be sent as an email, with the above requirement, which should auto capture from list 1

[k1dr0ck]

try

changed the linked sheet of sheet1 to the "attach" sheet
formula in list sheet K1 is a helper formula for the calculate sub
you can move it to ZZ1 put formula "=ZZ2"

Please Login or Register  to view this content.

[jimsenthil]

No working... can u help

[jimsenthil]

not working... can anyone help on this pls

[Croweater]

It's no use just saying it's 'not working'.

Add some value. Why is it not working? What errors do you get? Where did the code get the error?

[k1dr0ck]

when you filter a sales person on "list" sheet it is supposed to create the email with attachment of the filtered table
i have tested it on my end and its working

with the workbook that i attached as in nothing happens when you filter the table?