clvestin
11-03-2006, 09:59 PM
I would like to send mail from excel without having to open the Outlook app and wait for Send/Recieve.
Set objOLapp = New outlook.Application
Set objMailItem = objOLapp.CreateItem(0)
objMailItem.Recipients.Add ("Joe Blow")
With objMailItem
.To = Recipients
.Subject = " Morning Report"
.Attachments.Add "S:\PV\report.xls"
'.Display
.Send
End With
Is there a send Immediate ??
Set objOLapp = New outlook.Application
Set objMailItem = objOLapp.CreateItem(0)
objMailItem.Recipients.Add ("Joe Blow")
With objMailItem
.To = Recipients
.Subject = " Morning Report"
.Attachments.Add "S:\PV\report.xls"
'.Display
.Send
End With
Is there a send Immediate ??