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...
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
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.