A macro to do this......

[~§-/¥\-Ê-K~]

Anyone know a macro or some VB code that will do this:

1. save the current file
2. E-mail it to a certain address(probably gonna have to close the file 1st right)

so is that possible? will the macro continue to run once i close the file? Can excel e-mail for a start let alone e-mail attachments?

Any help appreciated

 

[dk]

How about this?

Sub SaveAndMail()
ActiveWorkbook.Save
ActiveWorkbook.SendMail "anyone@somewhere.com"
End Sub

HTH,
D

 

[~§-/¥\-Ê-K~]

yeah looks good, but will it send while the file is still open? spose i can just popup a messgae saying "close the file before sending the e-mail u sonofa.... no good...."

 

[~§-/¥\-Ê-K~]

Ohhh very nice! Excel even makes a temporary file to send. Me like!
Thanks man