Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    St Georges du Bois, Pays de la Loire
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add recipient to SendMail

    I am using the following to e-mail the active document:

    Sub send_active_doc()
    '
    ActiveDocument.SendMail

    End Sub

    Is there any way I can specify the recipient?

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add recipient to SendMail

    For some reason Excel appears to allow you to specify a recipient, but not Word.
    I think you may need to add a routing slip - in the VBA window, type 'recipient' and hit F1 - the help screen should come up with and explanation/example:

    Recipients Property Example

    This example adds a recipient to the routing slip attached to Sales.doc and then displays the name of the first recipient.
    <pre>If Documents("Sales.doc").HasRoutingSlip = True Then
    Documents("Sales.doc").RoutingSlip.AddRecipient _
    Recipient:="Aaron Con"
    MsgBox Documents("Sales.doc").RoutingSlip.Recipients(1)
    End If
    </pre>


    Recipients Property Example

    This example adds a recipient to the routing slip attached to Sales.doc and then displays the name of the first recipient.
    <pre>If Documents("Sales.doc").HasRoutingSlip = True Then
    Documents("Sales.doc").RoutingSlip.AddRecipient _
    Recipient:="Aaron Con"
    MsgBox Documents("Sales.doc").RoutingSlip.Recipients(1)
    End If
    </pre>


Posting Permissions

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