Hi,

I was wandering if anyone out there can help.
I have a folder (Z\statements\pdf's\) where i will have numerous pdf's stored.
The file names of these pdf's will be an email address.
So a file name could be: joebloggs@test.com.pdf , haroldbloggs@test.com.pdf etc...

What i need to do is to be able to extract the file name excluding the .pdf extension and attach this name as the email address and the actual pdf attachment in one email.
So i would have joebloggs@test.com as the email address and within the email i would have the pdf file as well.
Can a macro be created to do this?

I know how to create a macro and email the attachment but only when the email address is hard coded in the macro itself.


Thanks

Steve