In a custom Outlook message form, I am populating the CC field with a name
selected from a dropdown list by checking the "Set the initial value of this
field to:" checkbox on the Value properties tab of the CC field and inserting
the dropdown list name [Sponsor]. I have selected the radio button "Calculate
this formula automatically".

This works correctly. The selected name is inserted in the CC field once the
selection is made in the dropdown list. However, when the Send button is
clicked, I get an "Operation has failed" message. I have tried several
different ways of listing the names in the dropdown list, even using the SMTP
email address, but nothing works.

Can anyone help me with this problem?

Thanks in advance,
--
Yvetta

Are you resolving the recipients with Check Names before you send?

What version of Outlook? Is this a form for internal use only?

--
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

"Yvetta" wrote in message ...
In a custom Outlook message form, I am populating the CC field with a name
selected from a dropdown list by checking the "Set the initial value of this
field to:" checkbox on the Value properties tab of the CC field and inserting
the dropdown list name [Sponsor]. I have selected the radio button "Calculate
this formula automatically".

This works correctly. The selected name is inserted in the CC field once the
selection is made in the dropdown list. However, when the Send button is
clicked, I get an "Operation has failed" message. I have tried several
different ways of listing the names in the dropdown list, even using the SMTP
email address, but nothing works.

Can anyone help me with this problem?

Thanks in advance,
--
Yvetta

I would very much appreciate any code necessary for resolving the recipients
as you mention below. I have been looking through the books I have, and
figured that is probably what I need, but have not been able to work it out
for myself. I don't have any kind of programming background, so I pretty much
stumble through that.

We are on Outlook 2003. This will be an internal form, and will be published
to the Organizational Forms Library. Right now, I am just testing it myself.

Thanks for any help you can give,
--
Yvetta


"Sue Mosher [MVP-Outlook]" wrote:

Are you resolving the recipients with Check Names before you send?

What version of Outlook? Is this a form for internal use only?

--
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

"Yvetta" wrote in message ...
In a custom Outlook message form, I am populating the CC field with a name
selected from a dropdown list by checking the "Set the initial value of this
field to:" checkbox on the Value properties tab of the CC field and inserting
the dropdown list name [Sponsor]. I have selected the radio button "Calculate
this formula automatically".

This works correctly. The selected name is inserted in the CC field once the
selection is made in the dropdown list. However, when the Send button is
clicked, I get an "Operation has failed" message. I have tried several
different ways of listing the names in the dropdown list, even using the SMTP
email address, but nothing works.

Can anyone help me with this problem?

Thanks in advance,
--
Yvetta

I was suggesting that you test first by manually clicking the Check Names button to see if the name you have in mind will resolve manually. If it doesn't resolve manually, it won't resolve programmatically either.
--
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

"Yvetta" wrote in message ...
I would very much appreciate any code necessary for resolving the recipients
as you mention below. I have been looking through the books I have, and
figured that is probably what I need, but have not been able to work it out
for myself. I don't have any kind of programming background, so I pretty much
stumble through that.

We are on Outlook 2003. This will be an internal form, and will be published
to the Organizational Forms Library. Right now, I am just testing it myself.


In a custom Outlook message form, I am populating the CC field with a name
selected from a dropdown list by checking the "Set the initial value of this
field to:" checkbox on the Value properties tab of the CC field and inserting
the dropdown list name [Sponsor]. I have selected the radio button "Calculate
this formula automatically".

This works correctly. The selected name is inserted in the CC field once the
selection is made in the dropdown list. However, when the Send button is
clicked, I get an "Operation has failed" message. I have tried several
different ways of listing the names in the dropdown list, even using the SMTP
email address, but nothing works.

Can anyone help me with this problem?

Thanks in advance,
--
Yvetta

Unfortunately, clicking on the Check Names button does not resolve the name.
It's very confusing that it would not even send to a valid email address.
I'll have to rethink this and see if I can come up with a different way of
accomplishing what the user wants.

Anyway, thanks for your time. It's great to have this forum and people like
yourself who are willing to help.
--
Yvetta


"Sue Mosher [MVP-Outlook]" wrote:

I was suggesting that you test first by manually clicking the Check Names button to see if the name you have in mind will resolve manually. If it doesn't resolve manually, it won't resolve programmatically either.
--
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

"Yvetta" wrote in message ...
I would very much appreciate any code necessary for resolving the recipients
as you mention below. I have been looking through the books I have, and
figured that is probably what I need, but have not been able to work it out
for myself. I don't have any kind of programming background, so I pretty much
stumble through that.

We are on Outlook 2003. This will be an internal form, and will be published
to the Organizational Forms Library. Right now, I am just testing it myself.


In a custom Outlook message form, I am populating the CC field with a name
selected from a dropdown list by checking the "Set the initial value of this
field to:" checkbox on the Value properties tab of the CC field and inserting
the dropdown list name [Sponsor]. I have selected the radio button "Calculate
this formula automatically".

This works correctly. The selected name is inserted in the CC field once the
selection is made in the dropdown list. However, when the Send button is
clicked, I get an "Operation has failed" message. I have tried several
different ways of listing the names in the dropdown list, even using the SMTP
email address, but nothing works.

Can anyone help me with this problem?

Thanks in advance,
--
Yvetta

It would certainly be possible with code behind the form if you want to go that route.

--
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

"Yvetta" wrote in message news
Unfortunately, clicking on the Check Names button does not resolve the name.
It's very confusing that it would not even send to a valid email address.
I'll have to rethink this and see if I can come up with a different way of
accomplishing what the user wants.

Anyway, thanks for your time. It's great to have this forum and people like
yourself who are willing to help.
--
Yvetta


"Sue Mosher [MVP-Outlook]" wrote:

I was suggesting that you test first by manually clicking the Check Names button to see if the name you have in mind will resolve manually. If it doesn't resolve manually, it won't resolve programmatically either.

"Yvetta" wrote in message ...
I would very much appreciate any code necessary for resolving the recipients
as you mention below. I have been looking through the books I have, and
figured that is probably what I need, but have not been able to work it out
for myself. I don't have any kind of programming background, so I pretty much
stumble through that.

We are on Outlook 2003. This will be an internal form, and will be published
to the Organizational Forms Library. Right now, I am just testing it myself.


In a custom Outlook message form, I am populating the CC field with a name
selected from a dropdown list by checking the "Set the initial value of this
field to:" checkbox on the Value properties tab of the CC field and inserting
the dropdown list name [Sponsor]. I have selected the radio button "Calculate
this formula automatically".

This works correctly. The selected name is inserted in the CC field once the
selection is made in the dropdown list. However, when the Send button is
clicked, I get an "Operation has failed" message. I have tried several
different ways of listing the names in the dropdown list, even using the SMTP
email address, but nothing works.

Can anyone help me with this problem?

Thanks in advance,
--
Yvetta

I'd definitely be interested if you could help me out with that.
--
Yvetta


"Sue Mosher [MVP-Outlook]" wrote:

It would certainly be possible with code behind the form if you want to go that route.

--
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

"Yvetta" wrote in message news
Unfortunately, clicking on the Check Names button does not resolve the name.
It's very confusing that it would not even send to a valid email address.
I'll have to rethink this and see if I can come up with a different way of
accomplishing what the user wants.

Anyway, thanks for your time. It's great to have this forum and people like
yourself who are willing to help.
--
Yvetta


"Sue Mosher [MVP-Outlook]" wrote:

I was suggesting that you test first by manually clicking the Check Names button to see if the name you have in mind will resolve manually. If it doesn't resolve manually, it won't resolve programmatically either.

"Yvetta" wrote in message ...
I would very much appreciate any code necessary for resolving the recipients
as you mention below. I have been looking through the books I have, and
figured that is probably what I need, but have not been able to work it out
for myself. I don't have any kind of programming background, so I pretty much
stumble through that.

We are on Outlook 2003. This will be an internal form, and will be published
to the Organizational Forms Library. Right now, I am just testing it myself.


In a custom Outlook message form, I am populating the CC field with a name
selected from a dropdown list by checking the "Set the initial value of this
field to:" checkbox on the Value properties tab of the CC field and inserting
the dropdown list name [Sponsor]. I have selected the radio button "Calculate
this formula automatically".

This works correctly. The selected name is inserted in the CC field once the
selection is made in the dropdown list. However, when the Send button is
clicked, I get an "Operation has failed" message. I have tried several
different ways of listing the names in the dropdown list, even using the SMTP
email address, but nothing works.

Can anyone help me with this problem?

Thanks in advance,
--
Yvetta

Strange thing happened. I was testing another part of this form and had
clicked on Run This Form, then I had to step away from my desk for a while.
When I came back, the name had been resolved. Apparently, there is a timing
factor somehow involved. Any thoughts on that? Anyway to have it resolve more
quickly?
--
Yvetta


"Yvetta" wrote:

I'd definitely be interested if you could help me out with that.
--
Yvetta


"Sue Mosher [MVP-Outlook]" wrote:

It would certainly be possible with code behind the form if you want to go that route.

--
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

"Yvetta" wrote in message news
Unfortunately, clicking on the Check Names button does not resolve the name.
It's very confusing that it would not even send to a valid email address.
I'll have to rethink this and see if I can come up with a different way of
accomplishing what the user wants.

Anyway, thanks for your time. It's great to have this forum and people like
yourself who are willing to help.
--
Yvetta


"Sue Mosher [MVP-Outlook]" wrote:

I was suggesting that you test first by manually clicking the Check Names button to see if the name you have in mind will resolve manually. If it doesn't resolve manually, it won't resolve programmatically either.

"Yvetta" wrote in message ...
I would very much appreciate any code necessary for resolving the recipients
as you mention below. I have been looking through the books I have, and
figured that is probably what I need, but have not been able to work it out
for myself. I don't have any kind of programming background, so I pretty much
stumble through that.

We are on Outlook 2003. This will be an internal form, and will be published
to the Organizational Forms Library. Right now, I am just testing it myself.


In a custom Outlook message form, I am populating the CC field with a name
selected from a dropdown list by checking the "Set the initial value of this
field to:" checkbox on the Value properties tab of the CC field and inserting
the dropdown list name [Sponsor]. I have selected the radio button "Calculate
this formula automatically".

This works correctly. The selected name is inserted in the CC field once the
selection is made in the dropdown list. However, when the Send button is
clicked, I get an "Operation has failed" message. I have tried several
different ways of listing the names in the dropdown list, even using the SMTP
email address, but nothing works.

Can anyone help me with this problem?

Thanks in advance,
--
Yvetta

You should be able to resolve names manually by clicking the Check Names button on the toolbar. What happens when you try?

Assuming the user can choose only one sponsor, you could put this code in the Item_Send event handler for the form:

Function Item_Send()
Const olCC = 2
Set recip = Item.Recipients.Add(Item.UserProperties("Sponsor") )
If recip.Resolve Then
recip.Type = olCc
Else
Item_Send = False
recip.Delete
MsgBox "The sponsor name -- " & _
Item.UserProperties("Sponsor") & _
" -- could not be resolved to an address."
End If
End Function

--
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

"Yvetta" wrote in message ...
Strange thing happened. I was testing another part of this form and had
clicked on Run This Form, then I had to step away from my desk for a while.
When I came back, the name had been resolved. Apparently, there is a timing
factor somehow involved. Any thoughts on that? Anyway to have it resolve more
quickly?
--
Yvetta


"Yvetta" wrote:

I'd definitely be interested if you could help me out with that.
--
Yvetta


"Sue Mosher [MVP-Outlook]" wrote:

It would certainly be possible with code behind the form if you want to go that route.

"Yvetta" wrote in message news Unfortunately, clicking on the Check Names button does not resolve the name.
It's very confusing that it would not even send to a valid email address.
I'll have to rethink this and see if I can come up with a different way of
accomplishing what the user wants.

Anyway, thanks for your time. It's great to have this forum and people like
yourself who are willing to help.
--
Yvetta


"Sue Mosher [MVP-Outlook]" wrote:

I was suggesting that you test first by manually clicking the Check Names button to see if the name you have in mind will resolve manually. If it doesn't resolve manually, it won't resolve programmatically either.

"Yvetta" wrote in message ...
I would very much appreciate any code necessary for resolving the recipients
as you mention below. I have been looking through the books I have, and
figured that is probably what I need, but have not been able to work it out
for myself. I don't have any kind of programming background, so I pretty much
stumble through that.

We are on Outlook 2003. This will be an internal form, and will be published
to the Organizational Forms Library. Right now, I am just testing it myself.


In a custom Outlook message form, I am populating the CC field with a name
selected from a dropdown list by checking the "Set the initial value of this
field to:" checkbox on the Value properties tab of the CC field and inserting
the dropdown list name [Sponsor]. I have selected the radio button "Calculate
this formula automatically".

This works correctly. The selected name is inserted in the CC field once the
selection is made in the dropdown list. However, when the Send button is
clicked, I get an "Operation has failed" message. I have tried several
different ways of listing the names in the dropdown list, even using the SMTP
email address, but nothing works.

Can anyone help me with this problem?

Thanks in advance,
--
Yvetta

Sorry it has taken me so long to get back to you on this. I had to drop this
for awhile to work on other projects.

This script worked perfectly. What a relief for me and my customer. Thanks
so much for your help.
--
Yvetta


"Sue Mosher [MVP-Outlook]" wrote:

You should be able to resolve names manually by clicking the Check Names button on the toolbar. What happens when you try?

Assuming the user can choose only one sponsor, you could put this code in the Item_Send event handler for the form:

Function Item_Send()
Const olCC = 2
Set recip = Item.Recipients.Add(Item.UserProperties("Sponsor") )
If recip.Resolve Then
recip.Type = olCc
Else
Item_Send = False
recip.Delete
MsgBox "The sponsor name -- " & _
Item.UserProperties("Sponsor") & _
" -- could not be resolved to an address."
End If
End Function

--
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

"Yvetta" wrote in message ...
Strange thing happened. I was testing another part of this form and had
clicked on Run This Form, then I had to step away from my desk for a while.
When I came back, the name had been resolved. Apparently, there is a timing
factor somehow involved. Any thoughts on that? Anyway to have it resolve more
quickly?
--
Yvetta


"Yvetta" wrote:

I'd definitely be interested if you could help me out with that.
--
Yvetta


"Sue Mosher [MVP-Outlook]" wrote:

It would certainly be possible with code behind the form if you want to go that route.

"Yvetta" wrote in message news Unfortunately, clicking on the Check Names button does not resolve the name.
It's very confusing that it would not even send to a valid email address.
I'll have to rethink this and see if I can come up with a different way of
accomplishing what the user wants.

Anyway, thanks for your time. It's great to have this forum and people like
yourself who are willing to help.
--
Yvetta


"Sue Mosher [MVP-Outlook]" wrote:

I was suggesting that you test first by manually clicking the Check Names button to see if the name you have in mind will resolve manually. If it doesn't resolve manually, it won't resolve programmatically either.

"Yvetta" wrote in message ...
I would very much appreciate any code necessary for resolving the recipients
as you mention below. I have been looking through the books I have, and
figured that is probably what I need, but have not been able to work it out
for myself. I don't have any kind of programming background, so I pretty much
stumble through that.

We are on Outlook 2003. This will be an internal form, and will be published
to the Organizational Forms Library. Right now, I am just testing it myself.


In a custom Outlook message form, I am populating the CC field with a name
selected from a dropdown list by checking the "Set the initial value of this
field to:" checkbox on the Value properties tab of the CC field and inserting
the dropdown list name [Sponsor]. I have selected the radio button "Calculate
this formula automatically".

This works correctly. The selected name is inserted in the CC field once the
selection is made in the dropdown list. However, when the Send button is
clicked, I get an "Operation has failed" message. I have tried several
different ways of listing the names in the dropdown list, even using the SMTP
email address, but nothing works.

Can anyone help me with this problem?

Thanks in advance,
--
Yvetta