I am making a personalized for in Outlook and I have several checkboxes on
it. I would like to have these check boxes, once checked, to add a usable
email address to the To, CC, or BCC fields. Curently I have a formula in the
Initial Value field that looks like this:
','')+';'+IIf([MFG/ASSY
','')+';'+IIf([CUTTING
','')+';'+IIf([OPERATION
'",'')

Of course John Doe will be replaced by actual adresses and you can see it is
a simple string of the same command. But when the names enter into the field
they are not recognized as mail addresses and do not send anything to anyone.
They look like email addresses and when I click send they go nowhere.

This is a bad idea for two reasons:

1) Creating messages with custom forms is a useful technique only if the recipients are all inside your own organization where everyone uses Outlook.

2) Complex formulas are very dificult to debug. I wouldn't even begin to try to figure yours out.

You'd be better off writing code to create a completely new message with your desired data in it.

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

"drgrasso" wrote in message ...
I am making a personalized for in Outlook and I have several checkboxes on
it. I would like to have these check boxes, once checked, to add a usable
email address to the To, CC, or BCC fields. Curently I have a formula in the
Initial Value field that looks like this:
','')+';'+IIf([MFG/ASSY
','')+';'+IIf([CUTTING
','')+';'+IIf([OPERATION
'",'')

Of course John Doe will be replaced by actual adresses and you can see it is
a simple string of the same command. But when the names enter into the field
they are not recognized as mail addresses and do not send anything to anyone.
They look like email addresses and when I click send they go nowhere.