Sending Email

[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?


Randy

 

[AnotherHiggins]

Have a look at .SendMail

For future reference, VBA/Macro-specific questions should be posted to forum707

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[randy700]

I think SendMail sends the workbook itself.
Will re-post in the proper forum.

thanks


Randy

 

[SkipVought]

Hi,

Google in Tek-Tips on CdoSend.

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

 

[AnotherHiggins]

Ah, I got ya.

Include in your post over there what email program you use (OutLook, Lotus Notes, GroupWise, etc.).

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.