How to automatically change my “FROM” when sending certain emails

We have a program at work that about 15 of us use. It is basically a testing/scoring software. Once we are done scoring, the program creates an email to the employee that we just scored. This email is created automatically from our own personal Outlook (2010) on our desktops. The FROM field obviously defaults to me, and I need it to be anonymous. I know that I can go in and change it manually each time I send the email, but I would like to know if there is a way to have these particular emails default to our generic email account which I have access to? I do not have any access to the source code of the program that generates the email. The subject will always be the same for these emails. Can I use that fact to have the FROM field change without me having to do it each time? Thank you in advance for any help on this.
humerickAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David SankovskySenior SysAdminCommented:
The only thing I can think of, is either changing the program you are using, but as you said you have no access to the source code, You might want to ask your IT team to make a special transport rule in your exchange server (Hoping you are using exchange)
Other than that I see no automatic solution for you I'm afraid.
0
Najam UddinCommented:
Not sure if this will work, but try putting this in macro

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
On Error GoTo ErrorHandler
    Dim oAccount As Outlook.Account
    For Each Account In Application.Session.Accounts
    If Account.DisplayName = "yourCommonEmail" Then
        oAccount = Account
    End If
    Next
    With Item
         .SendUsingAccount = oAccount
    End With
Exit Sub
ErrorHandler:
    
End Sub

Open in new window

0
David SankovskySenior SysAdminCommented:
Najam Uddin
Expert Comment 2015-11-04 at 23:27:54ID: 41189266
Not sure if this will work, but try putting this in macro
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
On Error GoTo ErrorHandler
    Dim oAccount As Outlook.Account
    For Each Account In Application.Session.Accounts
    If Account.DisplayName = "yourCommonEmail" Then
        oAccount = Account
    End If
    Next
    With Item
         .SendUsingAccount = oAccount
    End With
Exit Sub
ErrorHandler:
    
End Sub

Open in new window

                                         
While the logic behind the script is pretty much solid, it's still not Automatic.
Granted, it will change the sender address, but in my humble opinion running the script is basically the same as manually changing the address
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Najam UddinCommented:
Why he need to run this manually, when you can create macro, that will fire on send event.
0
David SankovskySenior SysAdminCommented:
Najam Uddin
Expert Comment 2015-11-04 at 23:34:17ID: 41189284
Why he need to run this manually, when you can create macro, that will fire on send event.

Such a bind would cause ALL of his mails to be sent from the generic e-mail account - he needs a rule to check for the subject.
0
Najam UddinCommented:
I appreciate your concern, Well in that case we can help him by getting more detail about subject line and update logic. I posted it as a possible to getting it done without needing source code.
1
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
That is indeed a way to get it automated. I'm confident the subject can be used to set up a rule for triggering VBA code. The only issue I see is that you need to trust that rule, as you have no way to check the function before you send the mail. (Because the rule can trigger only on send or receive.)
0
humerickAuthor Commented:
The subject line will always read as, "Call Score Report" if that helps.
0
David SankovskySenior SysAdminCommented:
well then, the rule should search for topics containing "Call Score Report".
but we might want to add an exception if it contains "RE" or "FW".
0
Najam UddinCommented:
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
On Error GoTo ErrorHandler
    If Item.Subject = "Call Score Report" Then
        Dim oAccount As Outlook.Account
        For Each Account In Application.Session.Accounts
        If Account.DisplayName = "" Then
            oAccount = Account
        End If
        Next
        With Item
             .SendUsingAccount = oAccount
        End With
    End If
Exit Sub
ErrorHandler:
    
End Sub

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.