View Single Post
  #2  
Old May 16th 08, 07:11 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Sending Custom Form from Access

You should not get a security prompt in Outlook 2007 if the machine has up-to-date anti-virus protection. Check the anti-virus status in Tools | Trust Center | Programmatic Access.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Boyd" wrote in message ...
I have the following Access VBA code to automatically send a custom
form:

Set myOlApp = CreateObject("Outlook.Application")
Set myNameSpace = myOlApp.GetNamespace("MAPI")
Set myFolder = myNameSpace.GetDefaultFolder(olFolderInbox)
Set myItems = myFolder.Items
Set objForm = myItems.Add("IPM.Note.PublishedFormName.oft")
... populate form properties from access table ...
objForm.Display
SendKeys "^{ENTER}"

This code works fine with Outlook 2003, but Outlook 2007 prompts the
user with a message regarding Ctrl+Enter to send the form .. they must
manually click Yes to proceed.

I replaced "objForm.Send" with "SendKeys ^{ENTER}" to prevent the
security prompt from displaying in O2003, but now I'm in a similar
situation w/ the new version.

Does anyone know of a workaround for this? I appreciate any direction
you have to offer.
Thanks,
Boyd

Ads