VBA to email sheet to current user

[AndyMan81]

Hi all,

Ok, I have created my file so that you can get the document emailed to yourself using VBA, however it is set that the sheet requires you to enter your email address into a range of cells which is then referenced to send the email.

What I am trying to do though is remove this section of code (as people aren’t entering their email address) so that when selecting the "email quote" button, VBA recognises the current users outlook email address and sends the email automatically.

Surely there must be a way as outlook effectively is opened when making this selection (so you will have a "from" reference which is the users email address).

Basically I am trying to code so that the email is opened, and the email is sent to the sender....

Any help or option on this would be great!!

Many thanks,

Andy.

[djh53]

http://stackoverflow.com/questions/1...-open-in-excel