send email via vba without prompt

[smakatura]

I am sending a document via email from a macro. I can get it to send but it asks me if I wish to allow each email I send. how can I set up my code so that it sends with no prompts.

my coding that works is below.

ActiveWorkbook.SendForReview _
        Recipients:="smakatura@atienterprises.edu", _
        Subject:=filename, _
        ShowMessage:=False, _
        IncludeAttachment:=True

 

[Arul.rajesh]

Check this out

http://www.rondebruin.nl/cdo.htm

 

[smakatura]

thanks, I will take a look and see if it works for me.