Posted by: Andy Grogan | August 20, 2007

"Send on Behalf" places item in the sender's sent items, rather than the From…

My word, does the title for this article make sense? – not sure that it does, but this is what I mean;

Your name is Bob, you work for a person called Sid, and Sid has set you up so you can send mail items on his behalf.

However the problem is, when you send something from your mailbox on Sid’s behalf, the item goes into your sent items rather than Sid’s – which means Sid has no reference to what has been sent – Sid is not happy.

This is the same scenario that my Directors PA contacted me about the other day and asked me to see if I could do something about it.

Now, I kind of suspected that this behavior was as Microsoft claims “by design” and this is just one of those things – I am also aware that there is software out there that can remedy this situation, however the following was on my mind:

  • My director is the type of chap that came from a Novell (yuck) background and no doubt would be amazed that his (my) Exchange server that cost the better part of £100K could not manage some as simple as transferring a “Sent on Behalf” mail to a sent items folder in his mailbox – he would see it as the message was sent in his name, therefore should end up in his sent items.
  • I personally object to purchasing software to perform this task.

The following is the solution that I came up with – admittedly it requires a slight change to how the person that is granted “Send on Behalf of” sends messages but it works!

Step 1 – Configure a rule on the person with “Send on Behalf of rights ” Outlook client:

From the tools menu in Outlook select the “Rules and Alerts” option which will open the following dialog box (this box applies to Outlook 2007 – but I have tested this article with all versions of Outlook from 2000, the process is pretty much the same for each version);

 Click on the “New Rule” option which is open the following dialog box;

From here in the section marked “Start from a blank rule” choose the “Check Messages after sending” option and then click on the “Next” button.

The screen will change to look like the following;

 

You need to select the “with specific words in the subject” option – essentially we are going to configure a specific verb that the person that is sending the mail item can place in the subject line which will uniquely identify the message – this will become important later.

When you have selected this option the dialog box will change to look like the following – you will notice that the bottom of the dialog has changed to reflect the option that you have chosen – you need to click on the “specific words” option which will open the “specific words or phrases to search for in the subject” dialog box;

Choose a unique word or phrase that can be placed in the rule (for example my directory is called Sam Curling) therefore the verb I chose was “SC:“ – type this in and click add then OK.

You will be returned to the rules Wizard – click on the next button and the screen will change to look like the following:

You need to now select the “CC th message to the people or distribution list” – you will notice that the bottom part of the dialog box will change and see that the “people or distribution list” option is underlined – click on this which will open up the Global Address List – choose the person that you are sending on behalf of then click ok and then click NEXT.

The next dialog box is for exceptions, click on the “Next” button.

The final dialog will require you to give the rule a name – name the rule and then click on the finish button – you will be prompted to accept that the rule will be “client only” this is ok.

Ok you have now configured the first part of this, what you will find now is when the delegate sends on behalf of and places the verb (in our case “SC:“) that we have choose anywhere in the subject line a copy of the mail item will appear in the “Inbox” of the managers account.

Step 2 – Configure a rule in the managers mailbox;

What we now need to do is logon to the managers account and configure a rule that will move the message into the sent items folder – the following is how we accomplish this:

From the tools menu in Outlook select the “Rules and Alerts” option which will open the following dialog box (this box applies to Outlook 2007 – but I have tested this article with all versions of Outlook from 2000, the process is pretty much the same for each version);

Click on the “New Rule” option which is open the following dialog box;

From here in the section marked “Start from a blank rule” choose the “Check Messages when they arrive” option and then click on the “Next” button.

The screen will change to look like the following;

 

Choose the “with specific words in the subject” option then from the bottom of the dialog click on the “specific words” which is underlined – then from the input dialog box that appears enter in the exact verb that we chose in the first steps of this article, when you are done, click “Add” and then “ok” then click on the “Next” button and the screen will change to look like the following;

Choose then “move it to the specified folder” and then from the bottom of the dialog box, click on the “move it to the specified folder” option which is underlined – you will notice that this then brings up the folder structure of the managers mailbox – choose the “Sent Items” folder and click OK.

Click on the “Next” button, and then “Next” again – specify a name for this rule and then click on the finish button (which will save this as a server side rule).

That’s is, now all you PA needs to remember is that when they send on behalf of – the need to add the verb from step 1 placed in the subject line, and a copy of the message will be added to the sent items of the managers mailbox.

 


Responses

  1. [...] “Send on Behalf” places item in the sender’s sent items, rather than the From… [...]

  2. There must be an easier way to do this. I’d rather not rely on the user having to type a specific string, for it to work.

  3. Hiya Keith, this is about the simplest way I found. If you turn something up that I didn’t let me know. However the one thing that I am certain about is the placement of the sent item is by design in Exchange.

    Cheers

  4. Clever way to get round that problem Andy, sure it will come in useful somewhere

  5. Clever solution! Any ideas on how to set things up so that Bob does not have access to Sid’s inbox?

  6. I’ve been doing this for users for a while now, using the Exchange 2007 Shell:

    You have two options:

    Send on behalf of:
    set mailbox “Joe Contoso” GrantSendOnBehalfTo “Jim Fabrikam”

    Send-As (send as someone else):
    add-adpermission “Joe Contoso” -extendedrights Send-As -user DOMAIN\fabrikam

    Hope this helps.

  7. Sorry – scrap that – I mis-read the problem!!!

  8. here’s another way to do it: add the manager’s mailbox to your outlook profile as an additional mailbox, but instead of using exchange protocol choose IMAP and provide the owa url to the manager’s mbox. Then from outlook you choose to send ( the From) from the manager’s mailbox. The sent mail is put into the manager’s mailbox Sent items with no need of rules moves etc. Works like a charm.

  9. Nice solution, Tomc.

    I had to use protocol http to get it working.

    One question: the message in Sent items displays all headers. Have a solution for that too?

  10. Guys, the above doesn’t seem to be working for me… Followed the entire process as described above…
    HELP!

  11. [...] “Send on Behalf” places item in the sender’s sent items, rather than the From… « telnet 127… "Your name is Bob, you work for a person called Sid, and Sid has set you up so you can send mail items on his behalf. [...]

  12. The easy way to do this is to go into bobs calendar, TOOLs > Macro > Visual Basic Editor
    Expand Project 1 > microsoft Office Outlook object > THisOutlookSession

    Paste in the following code. (replacing USERN with persons mailbox name).

    Private SentEntryID As String
    Private SentStoreID As String
    Private WithEvents objSentItems As Items
    Private MailItem As Outlook.MailItem

    Public Sub Application_Startup()
    ‘Retrieve ID for accessing non-default sent folder
    getStoreFolderID (“Mailbox – USERSN”)
    Set objSentItems = Application.Session.GetDefaultFolder(olFolderSentMail).Items
    End Sub

    Function getStoreFolderID(StoreName)
    ‘Gets the Shared Account Sent Folder
    Dim Store As Object
    Dim StoreFolder As Object
    Dim i As Integer
    Set Store = Application.GetNamespace(“MAPI”).Folders
    For Each StoreFolder In Store
    If StoreFolder.Name = StoreName Then
    For i = 1 To StoreFolder.Folders.Count
    If StoreFolder.Folders(i).Name = “Sent Items” Then
    SentEntryID = StoreFolder.Folders(i).EntryID
    SentStoreID = StoreFolder.Folders(i).StoreID
    Exit For
    End If
    Next
    Exit For
    End If
    Next
    Set Store = Nothing
    Set StoreFolder = Nothing
    End Function

    Private Sub objSentItems_ItemAdd(ByVal Item As Object)
    ‘Fired when something is added to personal “Sent Mail” folder
    If TypeOf Item Is Outlook.MailItem Then
    With Item
    Set MailItem = Application.GetNamespace(“mapi”).GetItemFromID(.EntryID, .Parent.StoreID)
    End With
    If MailItem.SentOnBehalfOfName = “USERN” Then
    Set DestinationFolder = Application.Session.GetFolderFromID(SentEntryID, SentStoreID)
    MailItem.Move (DestinationFolder)
    End If
    End If
    Set MailItem = Nothing
    End Sub

  13. Nice script mla1. Works nicely!
    :)

  14. Oh btw I had to replace the double and single quotes with non-formatted ones for this to work.

  15. Dudie,
    Hi, Can you please explain “double and single quotes with non-formatted one for this to work” as i m not from the programing line.

    Thanks a lot.

  16. Dudie,
    Hi, Can you please explain “double and single quotes with non-formatted one for this to work” as i m not from the programing line.

    Thanks a lot.

  17. @mukhtar: Use notepad to find and replace all curly quotes by straight quotes. This sites uses WordPress, therefor all unformatted quotes are converted to opening/ending quotes. You’ll have to manually undo that before you deploy the script.

  18. Great script! For your next trick. . . I get a message about accessing the Outlook address book (Outlook 2002) when it first runs, and you can ask it to give access up to 10 mins. How can I get rid of this message forever?

  19. stupid question maybe, but for the macro you say: (replacing USERN with persons mailbox name).

    Where do I get the exact persons mailbox name from? If I enter this name in the To field and click properties of this name, is it the Display Name you see?

    By the way; in the macro you have a USERN and a USERSN? Is this a typo and should I replace both? or is it really only the USERN?

    Thanks!

  20. Never mind mine first questions. I have got it working! Works like a charme!

  21. hey guys i’m having an issue i did everything asked on this thread but when i create a new email from the person sending on behalf i get an error saying
    Run time error ‘-936247287 (c8320009)’
    Could not open the item. Try again.
    when i debug it points to this line

    Set DestinationFolder = Application.Session.GetFolderFromID(SentEntryID, SentStoreID)

    can anyone help at all?

  22. Sorry to say, but the Novell GroupWise proxy feature is much better and easier than delegates. Migrating from a GroupWise environment to Exchange, this has been a really big problem!

  23. mla1 & Dudie,

    Thanks for the post, it has been working like
    a charm.

    However, I just installed Office SP2 and now it doesn’t work anymore. Do anyone might know what is the issue? I have try re-install Office then also SP2 with
    no joy.

    Thanks

  24. (repost so author gets notified) Great script! For your next trick. . . I get a message about accessing the Outlook address book (Outlook 2002) when it first runs, and you can ask it to give access up to 10 mins. How can I get rid of this message forever?

  25. okay … found the culprit.

    with Outlook SP2, if you check the From address, it is no longer contain “send on behalf” properties and this break the macro.

    anyone have an idea to fix this?


Leave a response

Your response:

Categories