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/