Send email using excel, how to change "FROM"

[nordicdust]

When I send emails from Excel to people in the office, I would like it to seem like the email came from the department and not me.
I can do it using CDO, is there a way with outlook.
And is there a way to use HTLMBody with CDO.

The code I use:

Please Login or Register  to view this content.

Using CDO to send I have this option.
FROM Where it shows "FORSIKRINGSAFDELINGEN"

Please Login or Register  to view this content.

[ByteMarks]

Try the .SentOnBehalfOfName property in Outlook

and .BodyFormat=1 for the CDO html body.

[nordicdust]

Thanks ByteMarks
I have tried the .SentOnBehalfOfName property but keep getting error, will try again.

Great with the .BodyFormat=1 for the CDO html body.
I will try that as well.

Thanks again!