Attach active workbook to an email with VBA

[Mpouklas]

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o>Hello Excel chaps,</o>
<o> </o>
I have a form that will be opened through a portal as a read only.<o></o>
<o> </o>
As soon as all the fields are filled I want the user to press Send and then automatically the following to be done:<o></o>
<o> </o>
1. Create a new email<o></o>
2. Set subject and recipient<o></o>
3. Attach the form at the email that was filled without saving it anywhere<o></o>
4. Then send

Could you advice me on the code to attach and send the active work book?

Cheers,

Georgios

​

 

[Domenic]

Have a look at the SendMail method of the Workbook object...

ActiveWorkbook.SendMail Recipients:="john@abc.com", Subject:="Test", ReturnReceipt:=False

Note that if the subject is omitted, the document name is used. Also, the default value for ReturnReceipt is False.

 

[Mpouklas]

Dear Domenic,

That was exactly what I need!

Thanks a lot mate, really appreciated!

 

[Domenic]

You're very welcome!