Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to send mails from Excel using Outlook

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 08-12-2008
Member
 
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.

Reply With Quote
  #2  
Old 08-12-2008
Member
 
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?
Reply With Quote
  #3  
Old 08-12-2008
XSI XSI is offline
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 05:45 PM.