PDA

View Full Version : excel to outlook



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

10west
11-03-2006, 11:11 PM
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 (http://www.a1vbcode.com) seems to have more net related, like email and spammers etc.

clvestin
11-04-2006, 06:42 PM
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.

clvestin
11-04-2006, 07:15 PM
Shouldn't
Set objOLapp = New outlook.Application open the application??