email Openworkbook

[Paul Norris]

Hi
I am hoping one of you could help, I have a workbook which I will be sending out via as 3rd party to individuals who have to fill out then return to myself, I am looking for a macro that will forward the openworkbook to my email address at the press of a send button, I have been looking through the search area within the site and have not found anything so I am helping one of you could help.

1. 3rd party to press send on openworkbook to auto email the results to a given email address

Thanks in advance
Paul

 

[VoG]

You should find something suitable here http://www.rondebruin.nl/sendmail.htm

 

[Paul Norris]

You should find something suitable here http://www.rondebruin.nl/sendmail.htm

Will give it a try and let you know, thanks

 

[Paul Norris]

Will give it a try and let you know, thanks

Thanks for your help, got a basic code which works fine
Sub email()
ActiveWorkbook.SendMail Recipients:="emailaddress"
End Sub

 

[VoG]

It doesn't get much simpler than that