Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    email attachment (Excel 2000)

    Is it possible to create a hypelink in a worksheet that not only creates a new email but also automaticaly attaches the worksheet to the outgoing email?

    Thanks

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: email attachment (Excel 2000)

    Are you saying that File|Send To|Mail recipient (as Attachment) doesn't meet your needs? If you are looking to automate a recurring process, can you be more specific? Is is always the same recipients? Will it always be the "same" file?
    Gre

  3. #3
    New Lounger
    Join Date
    Aug 2002
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: email attachment (Excel 2000)

    This is a workbook that is sent out to various individuals. I would like to create a link in the worksheet that automaticaly emails the workbook back to me after they have filed out their information.

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: email attachment (Excel 2000)

    It sounds as if the RoutingSlip property is one that you may wish to use. There are a number of references to it in VBA Online Help - including the following code snippet:<pre>Workbooks("BOOK1.XLS").HasRoutingSlip = True
    With Workbooks("BOOK1.XLS").RoutingSlip
    .Delivery = xlOneAfterAnother
    .Recipients = Array("Adam Bendel", _
    "Jean Selva", "Bernard Gabor")
    .Subject = "Here is BOOK1.XLS"
    .Message = "Here is the workbook. What do you think?"
    End With
    Workbooks("BOOK1.XLS").Route</pre>

    HTH
    Gre

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: email attachment (Excel 2000)

    Check out the code in Ron de Bruin's site

    Steve

Posting Permissions

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