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

--
Message posted from http://www.ExcelForum.com

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 wrote:

Hi,

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

Basically, someone has to open outlook, do a new message and then
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

Andy


---
Message posted from http://www.ExcelForum.com/

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 ", _
"subject goes here"
End Sub

-------------------


--
Message posted from http://www.ExcelForum.com

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"andycharger " wrote in message ...
Thanks.
However, I notice that the system asks a lot of questions such as
choose your email client, etc....

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

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


Code:
--------------------

Sub Mail_workbook_1()
ActiveWorkbook.SendMail ", _
"subject goes here"
End Sub

--------------------



---
Message posted from http://www.ExcelForum.com/