Macro for filtering the data and sending email

[Lohith Kumar]

Hello,

I am new to macros, I only know to record the macros and edit the way
I want the macro to be, I always browse to see if there is any code
already in the net which can help me, unfortunately i did found the
macro i needed this time. please assist.

I have an excel sheet which has 4000 lines of data, but it is only for
402 suppliers. All i want my macro to do is filter the supplier (I
give supplier name in input box) by name and if any data found copy
the data to different excel sheet and email this sheet. Hope you guys
will help me in getting a macro for this.

Thanks
Lohit

 

[Ron de Bruin]

You can start here

This will filter and copy to a new sheet
http://www.rondebruin.nl/copy5_1.htm

You can use this for example to mail this sheet
http://www.rondebruin.nl/mail/folder1/mail2.htm

Or only for Outlook
http://www.rondebruin.nl/mail/folder2/mail2.htm

 

[Ron de Bruin]

I forgot to tell you this:
In the comments in the code there is a example for a inputbox