A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

After Office 2007 SP2 install - Outlook 2007 macro no longer worki



 
 
Thread Tools Search this Thread Display Modes
  #11  
Old May 21st 09, 02:16 AM posted to microsoft.public.outlook.program_vba
rpratikno
external usenet poster
 
Posts: 5
Default After Office 2007 SP2 install - Outlook 2007 macro no longer w

Hi Ken,

Thanks for replying.

I do understand your explanation are what the Exchange features and default.
When you reply email on Sales mailbox, the email that you sent will go to the
profile sent items, which is not what our organisation want. That is the
reason I use the macro, we want the sent email of replying Sales mailbox not
to the profile's Sent Items, yet to the Sales mailbox's sent items.

What I found is on Outlook side (not Exchange), with Outlook SP2, the
SendOnBehalfOfName property is no longer contain the Sales' name. It is now
contain profile's name. This is not happening before Outlook SP2, I'm
wondering if this is a bug on Office SP2? I didn't make any changes on the
macro code. The exactly same macro works fine prior to Office SP2.

However, at the reply email receiver the sender name is correct, which is
"profile on behalf of sales". So I'm sure this is not the problem of Exchange
configuration.

Will you be able to confirm that this is a bug on Office SP2? Please do
correct me if I'm wrong.

Thank you very much for your thinking, it is much appreciated.


"Ken Slovak - [MVP - Outlook]" wrote:

The default mailbox is wherever the emails are delivered for that Outlook
profile. It would be the mailbox for that Exchange alias.

What shows up in From would depend on which alias is answering that email
and what permissions they have on the shared mailbox. You can have send on
behalf of permissions, which shows one thing in From. You can have
SendAs/ReceiveAs permissions, which allow you to send as if you were that
mailbox alias. For example, if I answer an email from my Sales mailbox the
answer goes out from Sales since I gave myself SendAs/ReceiveAs permissions
on that mailbox, even though I'm logged into my own mailbox.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"rpratikno" wrote in message
...
Hi Ken,

Thanks for trying to reproduce my scenario, I appreciate that. Could you
please define which one is default mailbox? I assume default mailbox is
the
sender mailbox, not the shared mailbox. Please correct me if I'm wrong.

The goal of this macro is to automatically move all email that a user
reply
from shared mailbox into shared mailbox's sent items, not to the user
sender/default sent items.

I used Macro "watch" to see string value on the MailItem property. When I
hit reply on shared mailbox's email, the MailItem's SharedOnBehalfOfName
property string value is the user's name instead of the shared mailbox's
name.

I did check what the recipient see on their side, the email From field is
"user on behalf of shared". On sender side (me) the email From field is
only
"user" without "on behalf of shared". So I'm positive the issue is on
Outlook
instead of Exchange server. I got 10 users having the same issue here.

Could you please assist me more further? Your help is much appreciated.



Ads
  #12  
Old May 21st 09, 02:46 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default After Office 2007 SP2 install - Outlook 2007 macro no longer w

I told you already that I tested this on Outlook 2007 SP2 and did not find
what you are finding. So it is not a bug in Outlook 2007 SP2. Why you see
the results you see I have no idea, but if it was a bug in the service pack
I'd see it here also on the 2 computers I tested on.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"rpratikno" wrote in message
...
Hi Ken,

Thanks for replying.

I do understand your explanation are what the Exchange features and
default.
When you reply email on Sales mailbox, the email that you sent will go to
the
profile sent items, which is not what our organisation want. That is the
reason I use the macro, we want the sent email of replying Sales mailbox
not
to the profile's Sent Items, yet to the Sales mailbox's sent items.

What I found is on Outlook side (not Exchange), with Outlook SP2, the
SendOnBehalfOfName property is no longer contain the Sales' name. It is
now
contain profile's name. This is not happening before Outlook SP2, I'm
wondering if this is a bug on Office SP2? I didn't make any changes on the
macro code. The exactly same macro works fine prior to Office SP2.

However, at the reply email receiver the sender name is correct, which is
"profile on behalf of sales". So I'm sure this is not the problem of
Exchange
configuration.

Will you be able to confirm that this is a bug on Office SP2? Please do
correct me if I'm wrong.

Thank you very much for your thinking, it is much appreciated.


  #13  
Old May 21st 09, 11:44 PM posted to microsoft.public.outlook.program_vba
bfoxall
external usenet poster
 
Posts: 1
Default After Office 2007 SP2 install - Outlook 2007 macro no longer w



"rpratikno" wrote:

Hi Ken,

Thanks for trying to reproduce my scenario, I appreciate that. Could you
please define which one is default mailbox? I assume default mailbox is the
sender mailbox, not the shared mailbox. Please correct me if I'm wrong.

The goal of this macro is to automatically move all email that a user reply
from shared mailbox into shared mailbox's sent items, not to the user
sender/default sent items.

I used Macro "watch" to see string value on the MailItem property. When I
hit reply on shared mailbox's email, the MailItem's SharedOnBehalfOfName
property string value is the user's name instead of the shared mailbox's name.

I did check what the recipient see on their side, the email From field is
"user on behalf of shared". On sender side (me) the email From field is only
"user" without "on behalf of shared". So I'm positive the issue is on Outlook
instead of Exchange server. I got 10 users having the same issue here.

Could you please assist me more further? Your help is much appreciated.

"Ken Slovak - [MVP - Outlook]" wrote:

I'm sorry, I can't reproduce that at all.

I tested with Outlook 2007 SP2 and any reply from a shared mailbox using the
From as the shared mailbox alias always provided SentOnBehalfOfName and the
equivalent MAPI property in the items going to Sent Items in the default
mailbox.

Original emails using that From also had that property on them.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"rpratikno" wrote in message
news
Hi Ken,

Thanks for the tips to start debugging =) I manage to found the cause.

After installing Outlook SP2, if we reply any group email on group
mailbox,
the email From field will no longer contain SendOnBehalf properties, which
definitely break the macro.

Do you have any suggestion to fix it?

Thanks.



  #14  
Old June 17th 09, 06:19 PM posted to microsoft.public.outlook.program_vba
Perfort
external usenet poster
 
Posts: 1
Default After Office 2007 SP2 install - Outlook 2007 macro no longer worki

I have the same problem.
I don't use your macro but a com plugin UniSent (same issue)
If you start a mail from scratch the problem doesn't exist
If you clear FromField + Retype what was there the problem doesn't exist
(Actually its enough to just hit enter in the AutoPoppulated FromField).
Big problem hope someone can solve it.

Morten

"rpratikno" wrote:

Hi guys,

I have a macro that will move all email sent with "sendonbehalf" properties
to the group mailbox. I found it on someone post and it has been working like
a charm until I installed Office SP2. 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.

Below is the code
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 - group")
Set objSentItems =
Application.Session.GetDefaultFolder(olFolderSentM ail).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(.En tryID,
.Parent.StoreID)
End With
If MailItem.SentOnBehalfOfName = "group" Then
Set DestinationFolder = Application.Session.GetFolderFromID(SentEntryID,
SentStoreID)
MailItem.Move (DestinationFolder)
End If
End If
Set MailItem = Nothing
End Sub

Any suggestion or thinking are welcomed.

Thanks.

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 2007 no longer installed after SP2 2007 Office Suites upda PGP Outlook - Installation 2 May 1st 09 12:16 PM
Since we installed Office 2007, Outlook 2003 no longer runs JacquesT Outlook - General Queries 1 January 27th 09 09:17 PM
SoundMAX audio no longer loads under Office 2007 install? JVRudnick Outlook - General Queries 1 January 3rd 08 07:34 PM
can't uninstall 2007 Trial to install Office 2007 Christopher Glaeser Outlook - Installation 0 February 16th 07 05:29 AM
outlook did not install with office 2007 FufkinPro Outlook - Installation 3 January 18th 07 11:35 PM


All times are GMT +1. The time now is 01:52 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2024 Outlook Banter.
The comments are property of their posters.