-
excel to outlook
I would like to send mail from excel without having to open the Outlook app and wait for Send/Recieve.
[VBA]
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
[/VBA]
Is there a send Immediate ??
-
Make the app invisible, after setting your options in Outlook to send/recieve auto. You might be able to send right out of Excel. Or hunt up the small paragraph of code it takes to email with other VB controls, that I've seen all over the place, but www.a1vbcode.com seems to have more net related, like email and spammers etc.
-
This is not a straightfporward operation. I've been over the range of late binding, early binding, etc. with no progress. The problem may lie in the Outlook itself, which has been set to send/recieve online/offline. tThis is the only option i see that might be send/recieve auto.
-
Shouldn't
Set objOLapp = New outlook.Application open the application??
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules