Sending Email from an Excel Macro 2

[randy700]

I have an Excel macro that I use to upload data to a mainframe. I'd like to add a final step that notifies the computer room that the data has been uploaded.

This code works in Access:

DoCmd.SendObject acSendNoObject, , , "me@domain.com", , , "Information Needed", "Testing email", False

Is there similar code that will work with Excel?
I looked at the .SendMail method, but it appears that is meant to send the workbook itself.


Randy

 

[SkipVought]

Hi,

Google in Tek-Tips on CdoSend for some code.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

Have a look here:
thread705-1369407

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[randy700]

Got it working.
Thank you both for the help.


Randy