Solved: Send from group email box?

[debauch]

We use a group email box in outlook. The automated notifcations I use via VBA are sent using my personal email box. Is it possible to send from the "group box"?

Snippet used to send
[vba]
With olMail
'.From = "here@groupbox.com" < doesnt work?
.To = iTo
.cc = iCC
.Subject = isubject
'.HTMLBody = SheetToHTML(ThisWorkbook.Sheets(1)) 'turn sheet 1 to HTML
.Body = iBody
'.Display use to test view of output
.Send
End With
Set olMail = Nothing
Set OlApp = Nothing
[/vba]

[JP2112]

We use a group email box in outlook. The automated notifcations I use via VBA are sent using my personal email box. Is it possible to send from the "group box"?

Snippet used to send
[vba]
With olMail
'.From = "here@groupbox.com" < doesnt work?
.To = iTo
.cc = iCC
.Subject = isubject
'.HTMLBody = SheetToHTML(ThisWorkbook.Sheets(1)) 'turn sheet 1 to HTML
.Body = iBody
'.Display use to test view of output
.Send
End With
Set olMail = Nothing
Set OlApp = Nothing
[/vba]

Check out the SentOnBehalfOfName Property of the Mail Item.

HTH,
JP

[debauch]

.....I swear I tried every property BUT that one. Awesome, thanks! (worked like a charm)

[JP2112]

Glad to hear it worked!



--JP