Outlook Macro not executing

Posted by Tim on Stack Overflow See other posts from Stack Overflow or by Tim
Published on 2010-05-17T07:20:31Z Indexed on 2010/05/17 7:40 UTC
Read the original article Hit count: 309

Filed under:

outlook

|

outlook-macro

|

vb.net

Hello all,

we are using an an outlook macro for incoming emails to unzip the attachments, log them in sql server and copy them to a special working folder where a windows service processes them.

The problems are:

the user must be logged in at the server otherwise the macro wont run. I think there is no workaround for this.
whenever a modal dialog pops up in outlook and waits for user input, the macro wont execute either (f.e. AutoArchive) I have stopped AutoArchiving all x-days in the options. Because its a productive environment, are there other possible windows preventing the macro to execute, which i must disable now?
Our outlook-macro solution surely is not the best because of above problems. Are there better alternatives to read emails, unzip attachments and move them to a working folder? My language is VB.Net and server OS is windows 2008.

Regards, Tim

© Stack Overflow or respective owner

Related posts about outlook

Outlook 2007 - Cannot start Outlook - Cannot open the Outlook window

as seen on Super User - Search for 'Super User'
I went to open Outlook 2007 on my Windows 7 32bit machine and it came up with this error: Cannot start Microsoft Office Outlook. Cannot open the Outlook window. The set of folders cannot be opened. The information store could not be opened. I have deleted and created a new profile in Control Panel… >>> More
How To Switch Back to Outlook 2007 After the 2010 Beta Ends

as seen on How to geek - Search for 'How to geek'
Are you switching back to Outlook 2007 after trying out Office 2010 beta? Here’s how you can restore your Outlook data and keep everything working fine after the switch. Whenever you install a newer version of Outlook, it will convert your profile and data files to the latest format. … >>> More
Outlook 2007 Backup to D:\Outlook Fails - Access Denied, Write-Protected or File In Use

as seen on Super User - Search for 'Super User'
I can successfully save the Outlook PST file to the default location on the C drive (C:\Documents and Settings\user\ ... \Outlook) but when I change the backup save to directory to Outlook on the D drive I get the error: Cannot copy Outlook: Access is denied. Make sure the disk is not full or write… >>> More
Communication between Outlook addin and Program Automating Outlook

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an application that uses the automation interfaces to Microsoft Outlook to create a mail message and then after it is sent save an archive of that email message in my application. I am hitting issues with a number of the third party encryption addins because by the time the Sent event fires… >>> More
prevent outlook stationery from showing up in my email (Outlook 2007)

as seen on Stack Overflow - Search for 'Stack Overflow'
There are some people in my office who insist on using cute stationery and some of it makes messages difficult to read. I really just want to read email on a white background with no distractions. Is there a way to disable stationery on incoming mail in Outlook? (Without switching to "plain text… >>> More

Related posts about outlook-macro

Outlook Macro not executing

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all, we are using an an outlook macro for incoming emails to unzip the attachments, log them in sql server and copy them to a special working folder where a windows service processes them. The problems are: the user must be logged in at the server otherwise the macro wont run. … >>> More
Outlook macro runs through 250 iterations before failing with error [migrated]

as seen on Programmers - Search for 'Programmers'
Description: I have an Outlook macro that loops through selected emails in a folder and writes down some info to a .csv file. It works perfectly up until 250 before failing. Here is some of the code: Open strSaveAsFilename For Append As #1 CountVar = 0 For Each objItem In Application.ActiveExplorer… >>> More
Outlook Macro to Search

as seen on Stack Overflow - Search for 'Stack Overflow'
What's the best way to automate this function? I want to be able to do this in Outlook 2010, (1)select a specific mail account (2)Key in a folder that I am looking for (3)Then have the macro/program fire off an "*" asterisk (4)Then insert the text that I keyed in step one. I am trying to automate… >>> More
Why does the VBA Editor open on its own sometimes?

as seen on Stack Overflow - Search for 'Stack Overflow'
I've created a small script in Outlook 2003 VBA that watches for new appointments, and sets them to tentative and no reminder as I create them. However, I now find that seemingly at random, the VBA editor will open itself. It doesn't happen when I actually use the new script, but it did happen this… >>> More
COM Interop without regasm

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm a limited user, and I need to write an Outlook macro that exposes a C# library in Outlook 2003 and 2007. I do not have any admin privilges at all, not even at install time, so I can't run RegAsm and I can't (I assume) write a managed add-in. Is there any way to call .Net code from VBA in this… >>> More