|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: access, custom, form, sending |
|
|
Thread Tools | Display Modes |
|
#1
May 15th 08, 04:22 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Sending Custom Form from Access
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 |
|
#2
May 16th 08, 06:11 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sending a custom form ( .oft file) to others | Susan | Outlook - Using Forms | 1 | February 7th 07 04:07 PM |
| How to access a custom control in an outlook form from my VBA code? | MeAgin | Outlook and VBA | 1 | January 23rd 07 05:39 AM |
| How do I get my custom Outlook Form to display in Web Access? | robert | Outlook - Using Forms | 1 | October 10th 06 04:43 PM |
| How to access custom field in Custom Form by C# | Minh Nguyen | Outlook - Using Forms | 3 | April 24th 06 03:32 PM |
| Can custom form data populate access database | jbtempe | Outlook - Using Forms | 1 | January 20th 06 03:02 PM |
Linear Mode
