BCC

[teenzbutler]

I created a BCC: field so that a specific user is copied anytime the form is
submitted. I want that same person to be BCC-ed when the form is forwarded
as well. For some reason, I cannot figure this out. Does anyone have any
information on this?

 

[Sue Mosher [MVP-Outlook]]

Are you setting the value of the Bcc property of the original item with an initial value? If not, how?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[teenzbutler]

Thanks for you reply. No, I did not set the initial value to this field.
Instead, I edited the field an manually inputted the email address. The
reason why I did it this way was because, when I checked the "Set the initial
value of this field to:" box, the users were unable to send the form. They
would get "Operation failed". It took me a while to figure out that it was
this setting that caused the problem. Even though I published the form to
the Organizational Library, it still would fail. Do you have any
suggestions?

 

[Sue Mosher [MVP-Outlook]]

Put code in the Item_Forward event handler to set the Bcc property of the new forward message to the desired address:

Function Item_Forward(ByVal ForwardItem)
ForwardItem.Bcc = "(e-mail address removed)"
End Function

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[teenzbutler]

Thanks Sue. I am testing the code with a new email address. However, I have
one problem, I cannot remove the old email address within the BCC field. I
did not input the email address in the field below "Set the initial value of
this field to:" I manually entered it within the BCC field itself by editing
the field. Now when I try and remove the email address, it won't go away.
Even if I delete the BCC field and create a new one, the old address
re-populates. I went into Advanced Properties to remove it, but nothing
works. What am I doing wrong?

 

[Sue Mosher [MVP-Outlook]]

I can't quite picture what you're doing, given that it is not possible to delete a standard field from any Outlook item.

The way to remove a recipient from a custom form is to run the form, remove the recipient, republish.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[teenzbutler]

I deleted the BCC field, and published the form. I opened the form, clicked
the To: button, and the BCC field is populating with the old email address.
How is that possible without the BCC field in the form? Is there a cache
somewhere that I am not aware of? I assume you need a BCC field in the form
in order for the code to work. Isn't that correct?

 

[teenzbutler]

I was able to remove the email from the BCC field. I have the code inserted,
however, when I forward the form, it is not BCC the email I entered in the
code.

 

[Sue Mosher [MVP-Outlook]]

You might have removed the control displaying the Bcc property, but you didn't remove the Bcc field. Removing a control just removes a control. It has no effect on the data.

Did you try what I suggested?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Sue Mosher [MVP-Outlook]]

Did you publish the form to the Organizational Forms library? Leave the "send form definition with item" box unchecked? Set the Forward action on the (Actions) page to use the published custom form? All those are necessary steps to get code to run on a forward item.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[teenzbutler]

Thanks Sue. I tried what you recommended, but it still doesn't work. The
BCC fied/control has been removed from the form. I went into the
(Properties) tab and made sure the "Send form defnition with item" is
unchecked. I went into the (Actions) tab, double-clicked the Forward action
and in "This action creates a form of the following type", I pointed the Form
name: to my form. After that, I published the form once again. The code I
have is:

Function Item_Forward(ByVal ForwardItem)
ForwardItem.Bcc = "(e-mail address removed)"
End Function

 

[Sue Mosher [MVP-Outlook]]

When you forward an item, does its Help | About This Form dialog give you the correct and current name and version information for the form?

If you put a MsgBox statement in the Item_Forward event handler, does the message box show?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[teenzbutler]

When I forward the form, I do not see anything in the Form Dialog box. The
Version, Form Number, and Contact are blank. I added a Msgbox to the script.
It now looks like this:

Function Item_Forward(ByVal ForwardItem)
ForwardItem.Bcc = "(e-mail address removed)"
MsgBox "This is a test"
End Function

I do not get prompted when I forward the form. What do you think?

 

[Sue Mosher [MVP-Outlook]]

For troubleshooting purposes, you should always apply a new version number on the (Properties) page of the form before you publishe a new version.

Does the item being forwarded reside in a folder in another user's mailbox?

To what forms library did you publish the form?
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[teenzbutler]

I added the verion and number in the properties tab. The item being
forwarded does not reside in a folder in another user's mailbox. I published
the form in the Organizational Forms Library.

 

[Sue Mosher [MVP-Outlook]]

So, when you forward now, do you get the right version in Help | About This Form both on the original message and the new forward message? You could also try adding a ForwardItem.Display statement to the Forward event handler.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[teenzbutler]

Thanks Sue. When I open the form, I go up into Help, and there is not an
option that states "About this form." This options appears once I forward
the form. After forwarding the form, I go up into Help > About this Form.
My version number appears properly. I can give the FowardItem.Display a try
and report back.

 

[teenzbutler]

Sue. I added the ForwardItem.Display but that did not work. My code looks
like this:

Function Item_Forward(ByVal ForwardItem)
ForwardItem.Bcc = "(e-mail address removed)"
ForwardItem.Display
MsgBox "This is a test"
Response.Cc = Item.SenderEmailAddress
End Function

I stand corrected on the version and form number. This information does
appear when you first send the form. I am not sure what else to try.

 

[Sue Mosher [MVP-Outlook]]

Response.CC? Don't you mean ForwardItem.CC?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[teenzbutler]

I removed that line. I was trying to have the form CC the originator as
well. But that didn't work. I don't think there is anything more I can try.
Do you?