Solved

How to keep Reply from going to everyone list.

Posted on 2007-12-05
6
418 Views
Last Modified: 2010-04-21
Hello Outlook Experts,
We are using 2003 on a POP3 account at our company and we have a slight dilemma. What is happening a lot of times is, when someone gets an email that was sent to the "everyone" list, they will click the "Reply" button, type a quick reply, and send that baby off instead of deleting the everyone@ourcompany.com address from the To: box and inserting the address of the person that sent the message. Heck, it's easy to do, I've done it a couple of times myself. Then it sends that message AGAIN with whatever they typed to everyone at our company. It's kind of getting to be an annoyance, not to mention taking up tons of mail server space. So, with that said, I have done some investigating to see if there is some sort of, I don't know, VBA macro or something that will intercept the "Reply" button click event and instead of sending it back to the everyone list, send it just to the person that sent the message in the first place.
See, we have a mail server with, I think MDaemon or something like that for our mail program and a lot of us have rules set up in Outlook that dumps all those emails to our "everyone" folder. I'm not a VBA guy or anything, I've never written anything with it, I'm just an ASP.Net web developer here but thought I would take a crack at trying to figure this thing out. It is really getting to be a nuisance.

If anyone has ANYTHING to offer I would appreciate it.

Thanks in advance...

RunForrestRun

p.s. They try to train all the new employees that if they click "Reply" to not send it back to the "everyone" list but sometimes it just happens.
0
Comment
Question by:RunForrestRun
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 9

Expert Comment

by:FilipZahradnik
ID: 20415873
If your mail server is Mdaemon (you might want to post the version), you can control mailing list behaviour in the server GUI:

1. In the main Mdaemon screen, go to Lists->Edit List
2. You will see a list of your mailing lists. Select Everyone@yourdomain.xyz
3. In the Options tab in Mailing List Editor, make sure the Reply-To address is blank (this will route replies to the sender)
4. In Routing Tab, select "Mdaemon will crack mail list" and tick "Generate unique Message-ID for each copy"
0
 
LVL 9

Expert Comment

by:FilipZahradnik
ID: 20415933
More on point 4 in my previous post: this will make a unique copy of the email for each recipient. This should assist Outlook in treating the email correctly and picking the right Reply-To address.
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 20419275
Kind of a blunt instrument, but you could the code below into the ThisOutlookSession VBA module.
It would check outgoing messages for that "all" email address, and prompt the user if it finds that
address.  If you go with this approach, you'll have to make sure macro security is not set to high
or very high.

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) 
    Dim recip As Recipient
    Dim Msg As Long 
    Const AllAddress As String = "everyone@company.com"
    If Item.Class = olMail Then 
        For Each recip In Item.Recipients
            If LCase(recip.Address) = AllAddress Then
                Msg = MsgBox("You used '" & AllAddress & "' in the" & _
                    " receipient list." & Chr(10) & Chr(10) & "Are you sure you " & _
                    "want to do that?", vbYesNo, "Please confirm")
                If Msg <> vbYes Then
                    Cancel = True
                    MsgBox "Message send canceled"
                End If
                Exit For
            End If
        Next
    End If 
End Sub

Open in new window

0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

Author Comment

by:RunForrestRun
ID: 20420325
'Morning guys,
these are all very good responses and I appreciate all of them. Okay, I'm not a VBA guy so here we go...In Outlook I go to Tools-->Macro-->Visual Basic Editor right? Then with the VB editor open in front of me and the VbaProject.OTM - Module1 code window open I just paste -- or type is what I like to do, helps me learn better (-: --  this code in there and save it right? Am I still on the right track? Of course I fix the AllAddress string to represent our real company.
Then I open up one of the "everyone" emails and click "Reply" to see if that does the trick?

RFR
0
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 20420396
RunForrestRun said:
>>Am I still on the right track?

Close.  Do not put the code in a regular VBA module (which your Module1 would be).  Under
VbaProject.OTM, look for Microsoft Office Outlook Objects.  Under that, look for
ThisOutlookSession.  *That* module is where you want the code to go.

After adding the code and clicking the save icon, you may have to close and relaunch
Outlook for it to take effect.  Also, make sure to check your macro security settings in the
Outlook UI (Tools|Macro|Security).  The code will not run if the security setting is High
or Very High.
0
 

Author Closing Comment

by:RunForrestRun
ID: 31412955
THAT'S WHAT I'M TALKING 'BOUT!!! Sweet, it worked Matthew. Thank you so much. At first it didn't work, it just went ahead and sent the email to the "everyone" list, but then I FINALLY decided to listen to you and set my macro security to Low, tried it again, and 'viola it threw the message.
Matthew thank you so much, FilipZ thank you too I really appreciate everyone's input; you guys are the Experts, that's why I LOVE Experts Exchange.

RFR
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question