hi there this is my first post.

what i have is an excel sheet the employees fill out. i would like to save the file as: network number (the number is pulled from a cell like A1) then email that newly saved file to an email that i have like [email protected]. the subject line and body needs to read here is the network number (cell A1). the employee can hit the send button. it has to work in both 2003 and 2007.

i can have it mail using the cell info using the hyperlink, and have it save the file name but i can't get it to do both.

any help would be great.