|
| 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 |
|
#1
November 17th 08, 09:35 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Iif statement on mail form
I'm designing a mail form for conference room reservations. The composer
checks Y/N checkboxes if they need food, beverage, laptop or projector. If both projector and laptop are unechecked, I want the cc text box to remain blank. Otherise, I want to populate the cc text box with my own email address. I've tried to change the datasource to: IIf([Projector]=0 and ") I've experimented with all kinds of parenthetical placements and keep getting syntax errors (missing brackets, missing parens, etc.). I hope someone can help. Thanks. -- Sandi 
|
| Ads |
|
#2
November 17th 08, 10:00 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Iif statement on mail form
I got it: Here's what worked: I can't see what's different than the original
other than the AND is all caps. Guess that matters. IIf([Projector]=0 AND ") original: IIf([Projector]=0 and ") "Sandi V" wrote: I'm designing a mail form for conference room reservations. The composer checks Y/N checkboxes if they need food, beverage, laptop or projector. If both projector and laptop are unechecked, I want the cc text box to remain blank. Otherise, I want to populate the cc text box with my own email address. I've tried to change the datasource to: IIf([Projector]=0 and ") I've experimented with all kinds of parenthetical placements and keep getting syntax errors (missing brackets, missing parens, etc.). I hope someone can help. Thanks. -- Sandi
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Word Macro Conditional Statement | hometeamjill | Outlook and VBA | 1 | March 24th 08 12:59 PM |
| Com Add-in for Publishing a customized form in a public folder and setting this form as deafult form for the calendar | Vidya[_2_] | Add-ins for Outlook | 0 | September 17th 07 09:47 AM |
| Form Mail | Tony Batchelor | Outlook Express | 7 | May 9th 07 03:58 PM |
| If then statement | Aggie G | Outlook - Using Forms | 3 | February 2nd 07 07:50 PM |
| New Mail Form | TrevorG | Outlook - Using Forms | 3 | September 21st 06 09:09 PM |
Linear Mode
