• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Search results

  1. M

    Import Categories from Outlook 2003

    Phil, I`m myself behind VBOffice. If you only need to sync the master category list (mcl) once, you can use the mentioned addin, which is free for 30 days. The described process of importing the *.reg file is limited to only 10 categories during the free trial period; a limitation that was...
  2. M

    Import Categories from Outlook 2003

    Since the Upgrade to Color Categories option can only find categories assigned to items in the pst file it maybe doesn´t restore all the master category list. Category-Manager can import the all the categories from the Registry . Open the registry editor, and navigate to...
  3. M

    Delete Emails from Senders in Shared Mailbox

    You need to set the variable "mynamespace" before using it. Right now it is set three lines after the one that throws the error.
  4. M

    Open & Save VBAProject.Otm using VBA Code

    Outlook doesn´t support that.
  5. M

    VBA BeforeItemMove event create rule to always move to its folder.

    Is objFolder_BeforeItemMove being called? You can test it by setting a breakpoint on to that line of code.
  6. M

    VBA BeforeItemMove event create rule to always move to its folder.

    In order to receive an event you need to declare a variable for the object with the With Events statement: Private WithEvents Inbox As Outlook.Folder Private Sub Application_Startup() Set Inbox = Application.Session.GetDefaultFolder(olFolderInbox) End Sub Now you can select the variable...
  7. M

    Remove text in subject using VBA

    He has copied that macro from my site. The array is used so users can extend it as easily as possible to remove more than just one text.
  8. M

    VBA Code to permanently delete selected email

    "obj" is a variable you´d used with the For Each loop. It is not a property of Item(i). The loop will be faster if you use variables so that every object has to be referenced as less as possible: dim items as outlook.items set items=deletedfolder.items for i.... set obj=items(i) if...
  9. M

    VBA Code to permanently delete selected email

    Sort the Items collection descending before the loop starts deletedfolder.items.sort "[Receivedtime]", true Then use a For i=1 to 50 loop instead of For Each.
  10. M

    Tracking Mail items being moved to folders

    As Diane mentioned, you´re mixing different code. Use ItemAdd, if you want to handle on item added to a folder. Use the loop through selected items if you want to handle items selected by the user. The For Each loop already loops through the items, giving you a ref on each selected item. Why do...
  11. M

    Outlook 2010 FASTEST METHOD TO ENUMERATE FOLDERS

    For Outlook 2016 using a For i= loop is faster than For Each. I haven´t tested that in earlier versions. And for Outlook 2010 and older (not sure about 2013) using the RDOFolder object from Dmitry´s Redemption is way faster than the OOM.
  12. M

    Download pdf attachments only if email subject has one of words

    After any changes to the code you need to run the Application_Startup procedure, or restart Outlook. Did you do that?
  13. M

    Copying data from e-mail attachement to EXCEL file via macro

    Great, now you see why the msgbox pops up, it´s because some emails have more than just the expected attachments. Your error is a logical one: You don´t know at which position the Excel attachment is, so you cannot display the "not found" message and leave the loop as soon as it hits a non Excel...
  14. M

    Copying data from e-mail attachement to EXCEL file via macro

    You´re kidding, aren´t you? Of course, debugging only works when the code is running.
  15. M

    Adding Macro to populate "to" "subject" "body" not deleting email string below.

    This adds something at the beginning of a property and keeps the stuff that already existsmsg.body="xxx" & vbcrlf & msg.body
  16. M

    Download pdf attachments only if email subject has one of words

    Yes, by default the Instr function is case-sensitve. Use it this way if instr(1,"xxx",vbtextcompare). You need to test it; I always forget whether vbTextCompare or vbBinaryCompare makes it case-insensitive. In order to check for more words, use it this wayif instr(...)>0 or instr(...)>0 then...
  17. M

    Download pdf attachments only if email subject has one of words

    set a breakpoint on this line: Private Sub inboxItems_ItemAdd(ByVal Item As Object) Then move an item into the folder. The code execution will stop at the breakpoint. Walk through it step by step by pressing f8, and see where it doesn´t do what you`d expect.
  18. M

    Copying data from e-mail attachement to EXCEL file via macro

    That should mean oOlAtch is declared as object, not as attachment. You can also open the local window to look at a variable´s content. Or select all the "oOlAtch.Filename", then press shift+f9.
  19. M

    Copying data from e-mail attachement to EXCEL file via macro

    Sure. You need to look at the content of the oOlAtch.Filename property. One method to do so is to hover with the mouse over "FileName". That should display the prop´s content in a tooltip.
  20. M

    Copying data from e-mail attachement to EXCEL file via macro

    When the code exec stops, look at the value in oOlAtch.Filename. It cannot end with ".xlsx" in lower cases else the msgbox wouldn´t be displayed.