Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code in an excel spreadsheet to send email. The sending
of the email works fine but it does not make excel the active window after sending. Is there a way to make excel active again so I can run other code without having to manually activate excel. Thanks Pat Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(olMailItem) With OutMail .To = " .CC = "" .BCC = " .Subject = "Machine Hours - Labor" .Body = "" .Attachments.Add ("\\epfilesrv\as400downloads\machine-labor\machine hours - labor.xls") End With Set OutMail = Nothing Set OutApp = Nothing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Emailing from Excel | Excel Discussion (Misc queries) | |||
Emailing with EXCEL | Excel Programming | |||
Emailing From Excel | Excel Programming | |||
Emailing in Excel VBA | Excel Programming | |||
Emailing from Excel | Excel Programming |