Embed email address into worksheet

[Annie1904]

I have created a worksheet for my staff to update weekly. When updated they
should email it to me. I would like to put in a link to my email address
which, when clicked, opens an e-mail and shows the worksheet as an
attachment. All they then have to do is press the send button. How do I do
this?

 

[Kevin B]

This is already a feature in Excel. Click FILE in the menu, select SEND TO
and then MAIL RECIPIENT (AS ATTACHMENT).

This opens Outlook with a new email message and the attached file, all the
user has to do is select the recipient and click the SEND button.

 

[Annie1904]

Yeah, I know, Kevin, but the user still has to add a few details. The way
I've described below means two clicks. I'm probably spoiling them, but, hey!

Anyway I think I've resolved this - found another entry when I searched
again using different words. See
http://www.rondebruin.nl/mail/folder1/mail5.htm

 

[Kevin B]

Well, I wasn't sure, so I started at the top.

I've used Ron's code in the past and I don't remember if he's noted that if
Outlook is the email application and all the patches are up to date the user
is going to have to click their way through several confirmation screens.
The first being a confirmation that an external application is attempting to
access Outlook, and if you're confirming email addresses against the global
email address book another confirmation dialog box pops up.

So much for living in the modern age.

I believe that you could by pass all of this with some command prompt
scripting but your network admins might get apoplectic about bypassing
company policy.

At any rate good luck.

 

[Ron de Bruin]

See
http://www.rondebruin.nl/mail/prevent.htm

 

[Kevin B]

Hey, thanks for the heads up, and thanks for all those other tips I've used
over the years.

As for the Outlook tip, I'm going to give it a try in an Access application
that's in production and see if I can mofidy the code to by-pass those clunky
confirmation screen.

Thanks again, Ron...