Attachment to an email

Hello,

How to I have a button on my excel sheet that I can click on that will then send the sheet as an attachment to and email? I have tried but it seems that it is trying to send it to outlook which is not my prefered mail account.

This attachment will be used by many people who may have different emails than I do so I cannot say I want it to go to outlook it needs to be able to determine what email the user has and then create an attachment that goes to the email. They can then click send and it goes to the intended address.

Hope I have explained it well

If this is a hard way of doing it I basically need the excel sheet to be sent to someone and need it the quickest and easiest way possible. I though I button type of thing would be best.

Look forward to hearing from you

Marie

This code enables you to send an email, but it uses the preferred client of Microsoft outlook to actually send the email, you can send the e-mail to whoever you want but it needs to send the e-mail from an account, for this it used Outlook.

Modify the details below and add the addresses of the people you want to send the e-mail to.

I suggest setting up your outlook with the address you want to send the email from, be this, hotmail/windows live, gmail or any exchange or pop server.

Please Login or Register  to view this content.

Hope this helps,

Mike