Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ActiveWorkbook.EnvelopeVisible (03)

    Is there a dropdown option equivalent to the following line of code?

    ActiveWorkbook.EnvelopeVisible = True

    Thanks,
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ActiveWorkbook.EnvelopeVisible (03)

    Excel 2002 has an E-mail button on the standard toolbar that toggles the envelope on/off. If it is not visible in your Excel 2003, use Tools | Customize to add the button, it can be found in the File category.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ActiveWorkbook.EnvelopeVisible (03)

    Hans,

    I thought I would be able to have the macro recorder record how to check the "request for read receipt". Unfortunately it does capture the code.

    Any thoughts or guidance would be appreciated.

    John

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ActiveWorkbook.EnvelopeVisible (03)

    The items in your screenshot are provided by Outlook, not by Excel, hence the macro recorder doesn't capture them. You have to write the code yourself, and you need to know Outlook VBA to do so. Here is an example:

    Sub Test()
    Dim ws As Worksheet
    Set ws = ActiveSheet
    With ws.MailEnvelope
    .Introduction = "Hello World"
    With .Item
    .Subject = "Excel workbook"
    .Recipients.Add "billg@microsoft.com"
    .ReadReceiptRequested = True
    End With
    End With
    ActiveWorkbook.EnvelopeVisible = True
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •