|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
May 20th, 2003, 12:25 PM
|
||||
|
||||
|
Excel macro help
I am writing a macro in excel that email the spreadsheet as an attachment using this code:
Application.Dialogs(xlDialogSendMail).Show _ arg1:="some_static_email@here", _ arg2:="Emailing this Work Sheet" my question is, how can i make VB automatically send the message so the user does not have to click send? btw, this opens up an outlook window. Thanks, rkelley
__________________
Cyber Fury - Affordable Web Design and Hosting
|
|
#2
May 21st, 2003, 12:46 AM
|
|||
|
|||
|
The following should work.
Code:
ActiveWorkbook.SendMail recipients:="emailaddress@here.com" This uses the VBA SendMail client rather that the Excel dialog boxes. HTH 
__________________
How can I soar like an eagle when I'm flying with turkey's?
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Excel macro help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
