Pop up Outlook account selection
I have an odd situation which I hope someone can be of assistance. My company is running outlook 2003 popping to our email provider. All of the outlook clients have 2 email accounts; the problem is that a grate number of employees are sending out forwards and new email messages through the wrong account. Is there a plug-in or app that will pop up the account selection when a new or forwarded email is generated forcing them to select the right one?
ASKER
That is precisely what I want them to do and and a reminder would work just fine. We are using Outlook 2003
The code in the snippet displays a generic question asking if the sender selected the correct account. If they answer "yes", then the message is sent. If they answer "no", then the message is not sent. Follow these instructions to use this.
1. Open Outlook.
2. Click Tools->Macro->Visual Basic Editor
3. If it's not already expanded, then expand Microsoft Outlook Objects.
4. Once expanded you should see ThisOutlookSession. Click on it.
5. Copy the code from the snippet and paste it into the right-hand code window.
6. Edit the code as needed. I placed a comment line where things can/should change.
7. Exit the editor. It'll save everything automatically.
8. Click Tools->Macro->Security.
9. Set the security level to Medium.
10. Close Outlook.
11. Launch Outlook.
12. When Outlook starts you'll receive a pop up dialog-box warning that ThisOutlookSession contains macros and asking if you want to enable them. You have to say yes and enable them for the code to work.
1. Open Outlook.
2. Click Tools->Macro->Visual Basic Editor
3. If it's not already expanded, then expand Microsoft Outlook Objects.
4. Once expanded you should see ThisOutlookSession. Click on it.
5. Copy the code from the snippet and paste it into the right-hand code window.
6. Edit the code as needed. I placed a comment line where things can/should change.
7. Exit the editor. It'll save everything automatically.
8. Click Tools->Macro->Security.
9. Set the security level to Medium.
10. Close Outlook.
11. Launch Outlook.
12. When Outlook starts you'll receive a pop up dialog-box warning that ThisOutlookSession contains macros and asking if you want to enable them. You have to say yes and enable them for the code to work.
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
'Edit the prompt and caption as desired.'
If MsgBox("Did you select the correct account to send through?", vbQuestion + vbYesNo, "Account Check") = vbYes Then
Cancel = False
Else
Cancel = True
End If
End Sub
ASKER
The code seems to work but it pops up under the message and you don't see it untill you go back to the inbox view, is there a way to make it pop up on the mesage that is being composed
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The last version drops you back to the inbox when send is clicked, I hate to be a pain but what I would like to happen is when you click send, the message box pops up over the message that was just composed, neither version of the code does that.
"what I would like to happen is when you click send, the message box pops up over the message that was just composed"
Which is exactly what happens with the second version when I use it.
Which is exactly what happens with the second version when I use it.
ASKER
When I click Yes or No it losses focus from the email and goes to the inbox
When you click "Yes" the message should disappear because the message has been sent. When you click "no" focus should return to the message.
ASKER
When you click YES the popup does dissappear and send the message, but when you click NO it also dissapears but does not take you back to the message, still sits at the inbox.
You must be using Word as your email editor. Word messes up a lot of things in Outlook, including how macros behave. I understand its benefits, but in my opinion it causes more problems than it's worth. This is one of them. If you switch the editor to Outlook, then you'll get the behavior you want. I can't change the way Outlook behaves with Word as the editor.
ASKER
Yep, that would be the problem, as soon as I unchecked use Word it functioned as designed. Thanks for your help Blue
You're welcome. I should have thought of the Word angle sooner.
Why you don't want let users select which mail profil they want to use, directly by start Outlook?
Control Panel -> Mail -> Profil ?
Control Panel -> Mail -> Profil ?
I don't think you can "force" them select the right account. Even if you display a popup they could still select the wrong account. If instead you want them to think about the account they're sending through, then I can provide some code that will display a reminder for each item sent. I'd just need to know the version of Outlook they are using.