 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Programming Forms / February 2006Reference Formula
Outlook 2000 Subject line is set to populate automatically from certain fields. This is the code: "REF # " & ":" & [Ref No] & " - " & "RefNoDate" & ":" & [RefNoDate] & " - " & "Vendor Name/#" & ":" & [Vendor Name and No] &":" & " - " & "Sequence #" & ":" &[SequenceNo] This is working fine except for the SequenceNo. This is a combo box. Is it possible to set this up? I tried changing SequenceNo to ComboBox1 but it did not work. thanks! What in particular doesn't work? Don't forget to put a space between the & and the field name.  SignatureSue 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 > Outlook 2000 > [quoted text clipped - 10 lines] > > thanks! All the fields listed in the code below populate in the Subject line except the Sequence number which is a combo box. I asked the user if she wanted to just forego the sequence number or lose the dropdown (only has 10 entries). I put the missing spaces and the seq# still wasn't there. I really need to buy your book! thanks! > What in particular doesn't work? Don't forget to put a space between the & and the field name. > [quoted text clipped - 12 lines] > > > > thanks! Double-check the name of the field that's bound to the combo box (or select it using the field picker to avoid typos). Does the All Fields tab correctly show the value for SequenceNo that you expect? SignatureSue 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 > All the fields listed in the code below populate in the Subject line except > the Sequence number which is a combo box. I asked the user if she wanted to [quoted text clipped - 4 lines] > >> What in particular doesn't work? Don't forget to put a space between the & and the field name. >> > Outlook 2000 >> > [quoted text clipped - 10 lines] >> > >> > thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.