Auto Email from Excel Help

Afternoon Guys

Im trying to setup auto email in excel using the code below ...

Basically i will have a list of data which will all have a fixed number EG: 041, 155 etc i want this then to look at another sheet and auto filter column A to these fixed values separately then look at another sheet to match the same value again and auto email the filtered data on a new workbook to the email address defined in a certain cell / column.

I also want it to name the workbook that is sent to another cell value and same for the Email Subject

Is anyone able to help with this ?

Please Login or Register  to view this content.

If anyone could assist me with this would be much appreciated.

Thanks

Dave

If anyone could assist me with this would be much appreciated.

This is something I do need to try and figure out

Thanks

Dave