Question Sending E-mails from Access (1 Viewer)

[Haynesey]

Hi,

I have used the SendObject functionality for years in Access. Having not used it for several months, it now seems to have stopped on the PCs in our office. It works fine using the same database on my home PC and when I connect to our network at work using citrix.

Is there a security patch that Microsoft have released to stop this from working or is there something else I am forgetting?

Thanks in advance.

Lee

 

[SOS]

What version of Access are you using?

 

[Haynesey]

Hi,

It is Access 2007. I have done a bit more digging. The PCs with the problem seem to have Windows SP 2. It seems to work with SP3. Is that right?

Cheers

Lee

 

[ghudson]

You can use code to send emails and you also avoid the annoying "allow" prompt that the send object method forces on your users if you are using Office 2007 or newer. Check out the simple code I posted @ Outlook 2007 & E-mails