Recent content by Omar

  1. O

    modify vba to run it as script rule

    okay it is working now, I have deleted the rule and re-created. Thank you Michael & Diane.
  2. O

    modify vba to run it as script rule

    I did Michael, here is what the code looks like now. Option Explicit Public Sub Test(Item As Outlook.MailItem) Dim xlApp As Excel.Application Dim xlWB As Excel.Workbook Dim xlSheet As Excel.Worksheet Dim vText As Variant Dim sText As String Dim vItem As Variant Dim...
  3. O

    modify vba to run it as script rule

    Diane thanks for taking the time to help me. when I remove that line, and run test it gave me a For Each Item In Application.ActiveExplorer.Selection Next Item
  4. O

    modify vba to run it as script rule

    I'm trying to modify the following code to use it as rule Script but for some reason I can not figure it out how to modify the following line For Each Item In Application.ActiveExplorer.Selection here is the full code Option Explicit Public Sub UpdateReport(Item As Outlook.MailItem) Dim...
  5. O

    Help! Can't set up IMAP for gmail

    maybe google is blocking outlook - See Devices with Access to your Google Account
  6. O

    Reply and Add CC

    lol :) "S" - Thanks Michael and Diane. its working now
  7. O

    Reply and Add CC

    I am getting Error when i add olCC, what am i doing wrong? Option Explicit '// Auto Replay with notes and email body- run Action Script '// http://www.slipstick.com/outlook/rules/run-script-rule-reply-message/ Public Sub ReplywithNote(Item As Outlook.MailItem) Dim olInspector As...
  8. O

    VBA Move EMail

    and VB Office tips & tricks help me a lot.
  9. O

    VBA Move EMail

    Thanks for your time Michael, I figured it out. here is the changes I made and it worked. Private Sub PrintAttachments(oMail As Outlook.MailItem) On Error Resume Next Dim colAtts As Outlook.Attachments Dim oAtt As Outlook.Attachment Dim sFile As String Dim sDirectory As String Dim...
  10. O

    VBA Move EMail

    help please, for some reason I can't get the email to move. it saves & prints but no errors either. Code is in ThisOutlookSession. '// use Declare PtrSafe Function with 64-bit Outlook Private Declare Function ShellExecute Lib "shell32.dll" Alias _ "ShellExecuteA" (ByVal Hwnd As Long, ByVal...
  11. O

    using macro to send attachments

    Thanks Diane.
  12. O

    using macro to send attachments

    I am using macro to send reports saved in c:\Reports and then move the files to c:\Complete once its send out. I was wondering if there is a way to auto run the macro if report files become available at C:\Reports folder. Or a macro code that can watch C:\Reports folder and then call the macro...
Back
Top