.From Email

[owntor]

How does one enter the from address using VBA? Is it possible?

I tried '.From', but this does not work.

Sub email()
Dim olApp As Object
Set olApp = CreateObject("outlook.application")
With olApp.CreateItem(0)
.To = to_email
' .from = from_email
.subject = "subject test"
.body = body
.Save
End With
Set olApp = Nothing

End Sub

[Marcster]

.SenderName
But it's read-only.

Marcster.

[owntor]

Marcster, thanks for you reply.

Since it's read only, it's not possible to write to that field then? Is there a way to trick outlook to do it?

[Marcster]

As it's a read-only field you can't write to that field.

There are ways to trick Outlook though.
But you can still trace who sent it.

Can I ask why you want to do this?.
As there maybe an easier way of doing what your trying to achieve?.

Marcster.

[owntor]

.SentOnBehalfOfName seems to work. It writes to the 'From' field at any rate.

This is for a mass company e-mailing that needs to come from a specific mailbox.

owntor