![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#3
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
date formulas / mathematics, setting a field one hour past another field value | cmonroe21 via OfficeKB.com | Outlook - Using Forms | 1 | March 18th 09 11:17 PM |
Copying Data form user field to custom field | [email protected] | Outlook - Using Contacts | 1 | September 4th 06 06:32 PM |
move phone numbers from company field to business field | Tyson | Outlook and VBA | 3 | June 9th 06 05:38 PM |
Adding Follow Up field to Field Chooser Programatically. | c | Outlook and VBA | 3 | February 25th 06 02:10 PM |
Populate Company field from Contact field in custom task form | Sue Mosher [MVP-Outlook] | Outlook - Using Forms | 0 | January 20th 06 07:37 PM |