
Signature
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
Dimon,
Does not work...
here is my code (in excel). Everything else is populated
Thanks!
=============
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.SentOnBehalfOfName = strFrom
.To = strTo
.CC = strCC
.BCC = ""
.Subject = strSubj
.HTMLBody = RangetoHTML(rng)
.display 'or use .Send
End With
On Error GoTo 0

Signature
______
Regards,
Greg
> MailItem.SentOnBehalfOfName
>
[quoted text clipped - 16 lines]
> > Regards,
> > Greg
Greg - 30 May 2008 17:51 GMT
it actually worked. sorry for confusion
> Dimon,
>
[quoted text clipped - 44 lines]
> > > Regards,
> > > Greg