Send emails from Excel
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Send emails from Excel

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    292
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I would like to have a macro which runs outlook express and attach the active worksheet to it and sends email to the address kept in another worksheet.

    Regards,

    Shamsuddeen

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Here is the code I use to e-mail the active worksheet. What it does is make a copy of the active sheet into another workbook then sends that sheet only. But, it uses Outlook not express, I've found the code to use Express but I have yet to add the code.


    Sub SendIt()
    Sheet1.Copy
    ActiveWorkbook.SaveAs Filename:="file name you wish to save.xls", _
    FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
    ReadOnlyRecommended:=True, CreateBackup:=False
    Application.Dialogs(xlDialogSendMail).Show _
    arg1:="email address", _
    arg2:="subject"

    End Sub

    keep you posted on the express thing.
    I appreciate the help from everyone at Mr. Excel.

    viper

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com