Hi Dave

You can use the Outlook object model
See my site for examples
http://www.rondebruin.nl/sendmail.htm

Use Late Binding (example on each Outlook page)
Then you can use .Display instead of .Send so the user must press the Send Button.

You can press the button automatic with SendKeys
But it is possible that this is not working for all your users
Application.SendKeys "%S"

Check out also this webpage (best option if you can use it)
http://www.rondebruin.nl/cdo.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dave_2k5" wrote in message
...

Yes all the users use Outlook


--
Dave_2k5
------------------------------------------------------------------------
Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667
View this thread: http://www.excelforum.com/showthread...hreadid=389836