Results 1 to 3 of 3

Thread: How to send mails from Excel using Outlook

  1. #1
    Join Date
    May 2008
    Posts
    351

    How to send mails from Excel using Outlook

    Has anybody already tried mailing from Excel?

    I have an Excel spreadsheet with a button inside. This button activates a macro that sends the active sheet attachment via Outlook. The problem is that Excel, via function xlDialogSendMail, calls Outlook. Then asks me to click send and I send the mail without opening Outlook.

    Do any one have experience in this field?

    My code for the button:

    Code:
    Private Sub CommandButton1_Click() 
    
    Dim Destination As String 
    Dim Source As String 
    
    Destination = "destination@free.com" 
    Source = "Source mail" 
    
    ActiveWorkbook.SendMail Destination, Source, False 
    
    End Sub
    I get a warning in this code.

  2. #2
    Join Date
    May 2008
    Posts
    945

    Re: How to send mails from Excel using Outlook

    I will say it as a mistake because it could not automatically create the message.
    Basically ensure that it is outlook and not excel that triggers the sending?

  3. #3
    Join Date
    May 2008
    Posts
    271

    Re: How to send mails from Excel using Outlook

    I know about this message. I have already done some research and found that it is a security introduced with SP3 for Office 2003. I have installed "Express ClickYes" software designed to automatically click YES.

Similar Threads

  1. cannot send mails on outlook 2003
    By genevievetully in forum Windows Software
    Replies: 2
    Last Post: 25-07-2011, 01:31 AM
  2. How to send mails from VC++ program rather than using outlook
    By Anne Heche in forum Software Development
    Replies: 6
    Last Post: 26-06-2011, 07:34 PM
  3. Unable to send reply to mails via Outlook in Windows Vista
    By Pikachoo in forum Technology & Internet
    Replies: 2
    Last Post: 20-02-2009, 10:01 PM
  4. I can't send mails in Outlook!!
    By Jose Banana in forum Windows Software
    Replies: 3
    Last Post: 08-08-2008, 11:39 AM

Posting Permissions

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