Excel Help

I have an Excel related question. Seems to me like this would be easy to do but I can't figure it out. I wanna create some sort of button (or link) that will automatically attach the spreadsheet to an email and send it to a specific email address. This is for an internal document so all email programs will be Outlook.

I know I can create a Hyperlink to an email address and even assign a specific subject line to it, but it doesn't attach anything automatically. And I know I can select File -> Send to -> Mail Recipient (as attachment). But then it doesn't populate the email address automatically.

I looked into adding a button and creating a macro to assign to the button, but I don't know shit about Visual Basic to be able to create a macro from scratch. I tried recording a macro, but when I went to test it, it didn't do what I wanted.

And on another note, this needs to work from any PC with Excel and Outlook without having to install new add-ons or anything.

Anybody got any ideas????

 

Post this question here: http://www.mrexcel.com/board2/viewforum.php?f=2&sid=a3bacf550a0a768611be485e5c1284d1

You will not believe what they can do to get you solutions. Use the search feature too...tons of help.

 

I'm sure it's possible but it's probably not worth the time.

 

Doesn't it sound like it should be easy to do???

 

not necessarily

It would require vba to interact with outlook. There could be alot going on there. Is the abillity to right click on it in the file explorer and send to outlook recipient not adequate?

You must be doing this for executives.

 

But the funcionality is already there to automatically attach the document to an email.... And the funcionality to click an email address hyperlink and send it is already there. That's why I'm sayin it should be easy to do.

 

this is so weird, I was trying to figure this out just the other day. I figured it would be pretty easy but I guess not. and yea, its for executives...I'm tired of getting faxes. keep me posted Ace..

 

It's even simpler. Why not use the built in functionality iunder the file menu of Excel?

File->Send to Mail Recipient

 

google search, first try

http://www.experts-exchange.com/Databases/MS_Access/Q_20869265.html