Sende on behalf / på vegne af via VBA

Very much doubt you can use DoCmd.SendObject for this, you'll probably need to use VBA code to do this which can give other issues.

You could try something like this

Function SendMail()
Dim objOl As Outlook.Application
Dim objPost As MailItem
   
    Set objOl = New Outlook.Application
    Set objPost = objOl.CreateItem(olMailItem)
   
   
    With objPost
        .Subject = "Subject goes here"
        .To = "eksperten@santhell.dk"
        .SentOnBehalfOfName = "On Behalf Of"
       
        .Body = "Hej Med dig!"
       
               
        .Send
       
    End With
End Function

you will need a reference to Outlook

tak Terry

Men hvordan laver jeg denne reference til Outlook ?

har googlet lidt om fundet dette, men kan ikke lige hitte ud af, at få det strikket rigtigt sammen..

http://stackoverflow.com/questions/24630378/i-need-to-code-for-the-correct-reference-to-ms-outlook-from-excel

mvh martens

Ctrl+G to get I code view, then Tools+References menu

then go down list until you find Microsoft Outlook Object Lib.

?

Hej Terry...
Det virker fint på min hjemmecomputer... men på vores intranet .. kan jeg ikke finde Outlook Object Lib ;o(

Men tak for hjælpen....

is outlook installed on the intranet machine?

I obviously dont know your companies setup, but I assume that you have an exchange server and a number of user PC's.

you say "Jeg har rettigheder på plads ( det er en Exchangeserver, der benyttes .. )".

So I assume that its the user PC's which you want to be able to use "on behalf" from. So where does the intranet machine come into the picture?


and thanks for the points