Thread: TO field
View Single Post
  #1  
Old August 11th 09, 12:01 AM posted to microsoft.public.outlook.program_forms
Wanda
external usenet poster
 
Posts: 29
Default TO field

Hi Sue:
This works good to bring up a message. My code was:
***********
Sub cmdTest_Click()
Set objTab1 = Item.GetInspector.ModifiedFormPages("General")
Set objControls = objTab1.Controls("cmbProv")
IF objTab1.Controls("cmbProv")= "Saskatchewan" THEN
msgBox "Hi"
End If
End Sub
***************
When I change msgBox "hi" to:
..TO = "moyerw"

a message comes up saying "Invalid or unqualified reference". Can I put
the address in the TO (recipient) field this way?
Thank you.
Wanda

"Sue Mosher [MVP]" wrote:

See http://outlookcode.com/article.aspx?ID=38 for information on the events
you can use to change the To field when the user selects from your combo
box. The details depend on whether the combo box is bound to an Outlook
property and, of so, which one.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Wanda" wrote in message
...
I have created a custom form. I have a drop down menu to be able to
select
a province. Is there a way when a certain province is selected that it
put
a certain address in the TO field on the form? When I put the code in
and
we try to send the form, it comes saying "There must be a least one name
or
distribution list in the To, CC or BCC box". If the form has something
in
one of the fields (TO, CC or BCC) and then with the code, it will add the
code I put in ... but originally, I don't want anything in the name
fields.
Is there a way around this? We are use XP-SP3 and Outlook 2003, sp3.
Thank you.
Wanda




Ads