I have found on the net code for a macro that sends the worksheet I'm working from to a particular person using outlook which is great but I would like the macro to do is look at a particular cell which would contain the name and location of the file to attach and send it as well, is that possible? Or is there an alternative way of doing this?