just a quick question..

Is it possible to force outlook to send an email. I have code which opens Outlook with a Report as the body etc, but i want to make it send.

Is that possible?

Sure; if you're using SendObject, one of the arguments determines whether it's sent or left open for editing by the user.

um, not using sendmail, using MailItem
MyItem = Outlook.Application.CreateItem(olMailItem)

There is a .Send command, however that brings up a warning message asking for confirmation, with a 5 second delay till you can accept.

any ideas?

I use a free utility called ClickYes; there's also Outlook redemption and probably other methods.

http://www.contextmagic.com/express-clickyes/