Automate excel and outlook using one set of code

[GiraffetheGeek]

Hi there,

I want to be able to create a button within an excel sheet that when pressed would email that spreadsheet as an attachment to a particular person.

I tried to record a macro to do this but only got:

Sub Email()
'
' Email Macro
' Macro recorded 26/9/2011 by xxxxxx
'
'
    Application.Dialogs(xlDialogSendMail).Show
End Sub

When the macro is run it only goes as far as the new email window.

Is there a way to code VBA to insert the email address and press the send button automatically?

 

[AlphaFrog]

This link should have the code you are looking for.
Example Code for sending mail from Excel
Ron de Bruin

 

[GiraffetheGeek]

Thats great cheers!