Access Send Email without warning

[jamesormi]

Hi,

Is it possible to send an email from access (using SendObject) without the attached warning appearing?

Thanks in advance.

 

[JANR]

This is a Outlook problem and not access, you can use outlook Redemtion solution found here: http://www.dimastr.com/redemption/

edit: or you can search this site for CDO

JR

 

[ghudson]

Office 2007 allows you to use code to create and send an email without the nag warnings. Search around for there are lots of examples on how to do it.

 

[dbDamo]

See my post (#10) in this thread:- http://www.access-programmers.co.uk/...411#post923411

To install CDO, go to Start>Settings>Control Panel>Add or Remove programs. With "Change or Remove Programs" selected, scroll down the list of currently installed programs, highlight Microsoft Office and press "Change" - this opens up Microsoft Office Setup.

Select the "Add or Remove features" radio button and press "Next".

Press the + button next to Microsoft Outlook

Click on the drop down list next to "Collaboration Data Objects" and select "Run all from My Computer".

Press Update - this installs CDO.

Make sure to set your references after