none
Microsoft Outlook 2010 VBA code for AutoBCC email when there is an attachment RRS feed

  • Question

  • Dear Microsoft Community

    I would like to know the VBA code for auto BCC email when there is an attachment.

    Although I found the VBA code for Auto BCC to somebody as follows but I could not find the code for the condition.

    -----------------------------------------------------------------------------------

    Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
    Dim objMe As Recipient
    Set objMe = Item.Recipients.Add("ayn@kddi.ph")
    objMe.Type = olBCC
    objMe.Resolve
    Set objMe = Nothing
    End Sub

    -------------------------------------------------------------------------------------

    Thank you in advance for your support.

    Regards,

    Keita

    Monday, July 11, 2016 9:49 AM

Answers