?
Solved

Outlook: VBA code automatically forward Unread email to another mailbox

Posted on 2012-03-15
6
Medium Priority
?
2,010 Views
Last Modified: 2012-03-20
Hi experts,

We have Outlook 2007 and Exchange 2007 in our org, there is a request to be able to forward all Unread emails from a mailbox to a different mailbox after 1 day or so, and it'll run automatically or scheduled task.

I've searched around but haven't seen a way to do this with Transport rules or Outlook rules.

I think it probably can be done by writing some VBA codes in Outlook to accomplish. If so, could anyone help or guide me how to do that? I know little to nothing about VBA

Is this possible?
0
Comment
Question by:tnguyenWIRB
  • 3
  • 3
6 Comments
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 37729662
Whilst it is possible using vba this would require the outlook client to be active ... Assuming so then we should be able to work something.

Chris
0
 
LVL 1

Author Comment

by:tnguyenWIRB
ID: 37729877
Hi Chris,

I guess so, if there's no other way such as Open Outlook, run the script, send unread message, close Outlook.
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 37730718
We could do it as a scheduled task for example hourly to run a script that does the business?
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 1

Author Comment

by:tnguyenWIRB
ID: 37730749
Yes, I was thinking about that too.

I forgot to say, I'd like to forward only the external emails and unread, not internal ones.

Thanks,
0
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 2000 total points
ID: 37732787
A bit of code to actually call a macro is as follows:

Dim objOL
Dim ctl
Dim cbr
Const msoControlButton = 1
Dim shell
   
    Set shell = CreateObject("wscript.shell")
    shell.Run "outlook.exe"
   
    Set objOL = CreateObject("Outlook.Application")
    Set cbr = objOL.ActiveExplorer.CommandBars("Standard")
    Set ctl = cbr.Controls.Add(msoControlButton)
    ctl.OnAction = "checkold"
'    ctl.Parameter = "fred"
    ctl.Execute
    ctl.Delete

Open in new window


check old needs to be a button in outlook that runs some code to do what you want.  A  piece of code to pick up any emails in the inbox that are unread and older than 1 day would be:

Sub send24()
Dim strFilter As String
Dim inboxItems As Items
Dim unreadItems As Items
    
    strFilter = "[received] <= '" & Format(DateAdd("h", -24, Now()), "ddddd h:nn AMPM") & "'"
    Set inboxItems = Application.Session.GetDefaultFolder(olFolderInbox).Items.Restrict(strFilter)
    strFilter = "[Unread] = True"
    Set unreadItems = inboxItems.Restrict(strFilter)
        For Each itm In unreadItems
            With itm.Forward
                .To = "fred@fred.com"
                .Subject = "Delayed response ... please process"
                .Display
            End With
        Next
    
End Sub

Open in new window


send24 is the code that in this case is executed by the button check old as called  by the script

Chris
0
 
LVL 1

Author Comment

by:tnguyenWIRB
ID: 37743202
Sorry for the late response Chris, it was a long weekend for me :)

We had to modify the script a bit for our needs but it worked,

Thank you for your help,
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
Exchange administrators are always vigilant about Exchange crashes and disasters that are possible any time. It is quite essential to identify the symptoms of a possible Exchange issue and be prepared with a proper recovery plan. There are multiple…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…
Suggested Courses
Course of the Month16 days, 9 hours left to enroll

862 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