Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Custom Form Send Permissions (http://www.outlookbanter.com/outlook-vba/35379-custom-form-send-permissions.html)

Boyd December 14th 06 07:08 PM

Custom Form Send Permissions
 
I've created a custom Outlook form that is published to the
Organizational Forms Library. The process for which this form is used
is as follows:
1) From within Access, I have code that opens an instance of the
Outlook form, populates fields based on data in my database, and sends
the Outlook form to a recipient.
2) The recipient receives the Outlook form, populates a few text boxes,
then clicks a Submit button. The vbScript behind this button changes
the "To" field to my email address, then sends and closes the form.
3) When I receive the completed Outlook form in my inbox, I import the
form data into my Access database thru code.

For this process to work successfully, I need to add each recipient as
a Delegate to my inbox. Otherwise, the Outlook form is bounced back to
them when they click Submit, with the following message: "You do not
have permission to send to this recipient."

What am I missing here? There has to be a way of sending Outlook
forms, and having them returned, without delegating access to my inbox.

Any help/direction is greatly appreciated.
Thanks,
Boyd


Sue Mosher [MVP-Outlook] December 15th 06 12:25 AM

Custom Form Send Permissions
 
The problem is that you're trying to resend a message that already has a From address of your own account. Two possible solutions:

1) Set the value of Item.SendOnBehalfOfName to the current user.

2) Forward the item instead of resending.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Boyd" wrote in message ups.com...
I've created a custom Outlook form that is published to the
Organizational Forms Library. The process for which this form is used
is as follows:
1) From within Access, I have code that opens an instance of the
Outlook form, populates fields based on data in my database, and sends
the Outlook form to a recipient.
2) The recipient receives the Outlook form, populates a few text boxes,
then clicks a Submit button. The vbScript behind this button changes
the "To" field to my email address, then sends and closes the form.
3) When I receive the completed Outlook form in my inbox, I import the
form data into my Access database thru code.

For this process to work successfully, I need to add each recipient as
a Delegate to my inbox. Otherwise, the Outlook form is bounced back to
them when they click Submit, with the following message: "You do not
have permission to send to this recipient."

What am I missing here? There has to be a way of sending Outlook
forms, and having them returned, without delegating access to my inbox.

Any help/direction is greatly appreciated.
Thanks,
Boyd


Boyd December 15th 06 03:50 AM

Custom Form Send Permissions
 
Thanks Sue, I appreciate the prompt reply.
With "Item.SendOnBehalfOfName" behind my submit button, I receive the
following error: "Object doesn't support this property or method".
Any ideas??

Boyd


Dmitry Streblechenko December 15th 06 05:03 AM

Custom Form Send Permissions
 
It is SentOnBehalfOfName

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Boyd" wrote in message oups.com...
Thanks Sue, I appreciate the prompt reply.
With "Item.SendOnBehalfOfName" behind my submit button, I receive the
following error: "Object doesn't support this property or method".
Any ideas??

Boyd


Sue Mosher [MVP-Outlook] December 15th 06 01:54 PM

Custom Form Send Permissions
 
Thanks! (The object browser is your friend, Boyd.)

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Dmitry Streblechenko" wrote in message ...
It is SentOnBehalfOfName

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Boyd" wrote in message oups.com...
Thanks Sue, I appreciate the prompt reply.
With "Item.SendOnBehalfOfName" behind my submit button, I receive the
following error: "Object doesn't support this property or method".
Any ideas??

Boyd


Boyd December 15th 06 07:21 PM

Custom Form Send Permissions
 
Thanks Sue and Dmitry!
Using "SentOnBehalfOfName" seems to work perfectly.

Boyd

Sue Mosher [MVP-Outlook] wrote:
Thanks! (The object browser is your friend, Boyd.)

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Dmitry Streblechenko" wrote in message ...
It is SentOnBehalfOfName

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Boyd" wrote in message oups.com...
Thanks Sue, I appreciate the prompt reply.
With "Item.SendOnBehalfOfName" behind my submit button, I receive the
following error: "Object doesn't support this property or method".
Any ideas??

Boyd



Boyd January 29th 07 07:37 PM

Custom Form Send Permissions
 
I'm running into another snag when using "SentOnBehalfOfName". My
custom form isn't responding to it consistently. My command button
has the following code within the Click event:
Set objPage = Item.GetInspector.ModifiedFormPages("Message")
Item.SentOnBehalfOfName = Item.UserProperties("To")
Item.To = "
Item.Send

I had a user who received an "undeliverable" message when clicking the
button, then tried clicking again, and the form sent without a
problem.
Is it possible that the value in the "To" field (which has resolved to
the users account name, not the email address) isn't being recognized
by the Exchange server? Is it better practice to use the actual
address, instead of the resolved name?

Any help is appreciated.
Thanks, Boyd


On Dec 15 2006, 1:21 pm, "Boyd" wrote:
Thanks Sue and Dmitry!
Using "SentOnBehalfOfName" seems to work perfectly.

Boyd



Sue Mosher [MVP-Outlook] wrote:
Thanks! (The object browser is your friend,Boyd.)


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Dmitry Streblechenko" wrote in . ..
It isSentOnBehalfOfName


Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool


"Boyd" wrote in ooglegroups.com...
Thanks Sue, I appreciate the prompt reply.
With "Item.SendOnBehalfOfName" behind my submit button, I receive the
following error: "Object doesn't support this property or method".
Any ideas??


Boyd- Hide quoted text -- Show quoted text -



Dmitry Streblechenko January 29th 07 09:19 PM

Custom Form Send Permissions
 
If you are using a name, you indeed can get error, even if the name come
from GAL due to ambiguity: e.g. if you specify "admin" and you have users
named "admin" and "administrator", you will get an ambiguous error.
Addresses are definitely better.

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Boyd" wrote in message
oups.com...
I'm running into another snag when using "SentOnBehalfOfName". My
custom form isn't responding to it consistently. My command button
has the following code within the Click event:
Set objPage = Item.GetInspector.ModifiedFormPages("Message")
Item.SentOnBehalfOfName = Item.UserProperties("To")
Item.To = "
Item.Send

I had a user who received an "undeliverable" message when clicking the
button, then tried clicking again, and the form sent without a
problem.
Is it possible that the value in the "To" field (which has resolved to
the users account name, not the email address) isn't being recognized
by the Exchange server? Is it better practice to use the actual
address, instead of the resolved name?

Any help is appreciated.
Thanks, Boyd


On Dec 15 2006, 1:21 pm, "Boyd" wrote:
Thanks Sue and Dmitry!
Using "SentOnBehalfOfName" seems to work perfectly.

Boyd



Sue Mosher [MVP-Outlook] wrote:
Thanks! (The object browser is your friend,Boyd.)


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Dmitry Streblechenko" wrote in
. ..
It isSentOnBehalfOfName


Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool


"Boyd" wrote in
ooglegroups.com...
Thanks Sue, I appreciate the prompt reply.
With "Item.SendOnBehalfOfName" behind my submit button, I receive the
following error: "Object doesn't support this property or method".
Any ideas??


Boyd- Hide quoted text -- Show quoted text -





Boyd January 30th 07 07:58 PM

Custom Form Send Permissions
 
Thanks Dmitry. I changed the "SentOnBehalfOfName" to the user's email
address, instead of the outlook account name, but the user is still
receiving the returned "undeliverable" message.

Does anyone have an example using "SentOnBehalfOfName" that works for
them? I really want to avoid adding every possible user as a delegate
to my Inbox.

Thanks,
Boyd

On Jan 29, 3:19 pm, "Dmitry Streblechenko" wrote:
If you are using a name, you indeed can get error, even if the name come
from GAL due to ambiguity: e.g. if you specify "admin" and you have users
named "admin" and "administrator", you will get an ambiguous error.
Addresses are definitely better.

Dmitry Streblechenko (MVP)http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Boyd" wrote in ooglegroups.com...



I'm running into another snag when using "SentOnBehalfOfName". My
custom form isn't responding to it consistently. My command button
has the following code within the Click event:
Set objPage = Item.GetInspector.ModifiedFormPages("Message")
Item.SentOnBehalfOfName = Item.UserProperties("To")
Item.To = "
Item.Send


I had a user who received an "undeliverable" message when clicking the
button, then tried clicking again, and the form sent without a
problem.
Is it possible that the value in the "To" field (which has resolved to
the users account name, not the email address) isn't being recognized
by the Exchange server? Is it better practice to use the actual
address, instead of the resolved name?


Any help is appreciated.
Thanks, Boyd


On Dec 15 2006, 1:21 pm, "Boyd" wrote:
Thanks Sue and Dmitry!
Using "SentOnBehalfOfName" seems to work perfectly.


Boyd


Sue Mosher [MVP-Outlook] wrote:
Thanks! (The object browser is your friend,Boyd.)


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Dmitry Streblechenko" wrote in
. ..
It isSentOnBehalfOfName


Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool


"Boyd" wrote in
ooglegroups.com...
Thanks Sue, I appreciate the prompt reply.
With "Item.SendOnBehalfOfName" behind my submit button, I receive the
following error: "Object doesn't support this property or method".
Any ideas??


Boyd- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -



Dmitry Streblechenko January 30th 07 09:19 PM

Custom Form Send Permissions
 
What exactly dod you mean by "undeliverable"? What is thee exact error
message?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Boyd" wrote in message
oups.com...
Thanks Dmitry. I changed the "SentOnBehalfOfName" to the user's email
address, instead of the outlook account name, but the user is still
receiving the returned "undeliverable" message.

Does anyone have an example using "SentOnBehalfOfName" that works for
them? I really want to avoid adding every possible user as a delegate
to my Inbox.

Thanks,
Boyd

On Jan 29, 3:19 pm, "Dmitry Streblechenko" wrote:
If you are using a name, you indeed can get error, even if the name come
from GAL due to ambiguity: e.g. if you specify "admin" and you have users
named "admin" and "administrator", you will get an ambiguous error.
Addresses are definitely better.

Dmitry Streblechenko (MVP)http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Boyd" wrote in
ooglegroups.com...



I'm running into another snag when using "SentOnBehalfOfName". My
custom form isn't responding to it consistently. My command button
has the following code within the Click event:
Set objPage = Item.GetInspector.ModifiedFormPages("Message")
Item.SentOnBehalfOfName = Item.UserProperties("To")
Item.To = "
Item.Send


I had a user who received an "undeliverable" message when clicking the
button, then tried clicking again, and the form sent without a
problem.
Is it possible that the value in the "To" field (which has resolved to
the users account name, not the email address) isn't being recognized
by the Exchange server? Is it better practice to use the actual
address, instead of the resolved name?


Any help is appreciated.
Thanks, Boyd


On Dec 15 2006, 1:21 pm, "Boyd" wrote:
Thanks Sue and Dmitry!
Using "SentOnBehalfOfName" seems to work perfectly.


Boyd


Sue Mosher [MVP-Outlook] wrote:
Thanks! (The object browser is your friend,Boyd.)


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Dmitry Streblechenko" wrote in
. ..
It isSentOnBehalfOfName


Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool


"Boyd" wrote in
ooglegroups.com...
Thanks Sue, I appreciate the prompt reply.
With "Item.SendOnBehalfOfName" behind my submit button, I receive
the
following error: "Object doesn't support this property or method".
Any ideas??


Boyd- Hide quoted text -- Show quoted text -- Hide quoted text --
Show quoted text -






All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com