How To Embed Link That Mails My Workbook

[Mike]

I've created a workbook that I want the users to be able to E-mail back to me
easily once they have entered their data. My hope is that I can embed
something like a mailto link that is easy for them to see and click on and
that automatically ques up Outlook to send the file back to me if the user
clicks on it.

Is it possible?

Thanks,
Mike

 

[Joel]

The way to do this is using a macro. I would add a control button onto the
worksheet to which would email the worksheet back to you. See Ron De bruins
webpage on email macros for the code. You would need to add a control button
to the worksheet which I can explain. the task isn't very complicated. You
would just need to copy one of the examples on ron's webpage with a few minor
modifications.

http://msdn.microsoft.com/en-us/library/bb268022.aspx