Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sendmail/Email (Excel97)

    Does anyone know how I can, from VBA in Excel97, have a macro to email the currently active workbook to whoever@whereever.com? It must be able to work with both Outlook and Outlook Express.

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

    Re: Sendmail/Email (Excel97)

    The SendMail method of a workbook should do this:
    <pre>ActiveWorkbook.SendMail Recipients:="whoever@whereever.com", _
    Subject:="Sales Forecast", ReturnReceipt:=True</pre>

    The Recipients argument is required, the other two are optional.
    If you omit ReturnReceipt, it is assumed to be false.
    If you omit Subject, the workbook name is used as subject.

Posting Permissions

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