Emailing my spreadsheet?

[andycharger]

Hi,

I was wondering how I go about emailing my spreadsheet at the end of m
macro...

Basically, someone has to open outlook, do a new message and the
attach todays file using windows explorer to find it.
They also enter a TO address and then press send.

Is there a way to email it directly as part of the macro?

If so it would cut out the manual part at the end of my macro.

Any examples of code would be appreciated.

Thanks in advance

And

 

[keepITcool]

visit http://www.rondebruin.nl

my fellow countryman is the definite source on emailing from excel.

btw: !!! THANX to the CZECHS !!!!
we owe you one
H O L L A N D


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[andycharger]

Thanks.
However, I notice that the system asks a lot of questions such a
choose your email client, etc....

Is there a way to just send the email automatically without huma
intervention?

I have used application.displayalerts = false before but not sure i
this is enough for emailing.


Code
-------------------

Sub Mail_workbook_1()
ActiveWorkbook.SendMail "(e-mail address removed)", _
"subject goes here"
End Sub

 

[Ron de Bruin]

Look here Andy
http://www.rondebruin.nl/mail/prevent.htm