A macro to do this......

~§-/¥\-Ê-K~ · Mar 23rd, 2002, 01:22 PM

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 · Mar 23rd, 2002, 01:34 PM

How about this?

Code:

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

HTH,
D

~§-/¥\-Ê-K~ · Mar 23rd, 2002, 01:39 PM

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~ · Mar 23rd, 2002, 01:44 PM

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

Mar 23rd, 2002, 01:22 PM	#1
~§-/¥\-Ê-K~ New Member Join Date: Feb 2002 Posts: 10	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
$~§-/¥\-Ê-K~ is offline$

Mar 23rd, 2002, 01:34 PM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	How about this? Code: Sub SaveAndMail() ActiveWorkbook.Save ActiveWorkbook.SendMail "anyone@somewhere.com" End Sub HTH, D

Mar 23rd, 2002, 01:39 PM	#3
~§-/¥\-Ê-K~ New Member Join Date: Feb 2002 Posts: 10	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~ is offline$

Mar 23rd, 2002, 01:44 PM	#4
~§-/¥\-Ê-K~ New Member Join Date: Feb 2002 Posts: 10	Ohhh very nice! Excel even makes a temporary file to send. Me like! Thanks man
$~§-/¥\-Ê-K~ is offline$

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode