![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
thank you both for your help. It is greatly appreciated.
-- ______ Regards, Greg "Sue Mosher [MVP-Outlook]" wrote: First, a macro is an argumentless subroutine, so what you want to call is a sub, not a macro. It sounds like what you want to do is parameterize the path, in which case, you add it as an argument to the SaveAttachment procedu Sub SaveAttachment(MyMail As MailItem, strPath as String) removing, of course, the strPath= statement from that procedure. To call it, you provide the values for the procedure's arguments: Sub Save2HM(MyMail As MailItem) strPath = "\\ad\gbs$\Download\HM\" Call SaveAttachment(MyMail, strPath) End Sub -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Greg" wrote in message ... thank you. will use Option Explicit going forward. My next question is how to call this macro from the other procedure? I need several of them for several rules and the only difference will be the file path. ----------------------- Sub Save2HM(MyMail As MailItem) strPath = "\\ad\gbs$\Download\HM\" Call SaveAttachment End Sub then Sub Save2BLP(MyMail As MailItem) strPath = "\\ad\gbs$\Download\BLP\" Call SaveAttachment End Sub etc. Thank you -- ______ Regards, Greg "JP" wrote: You declared "objNS" as the Namespace but you are setting objMail to "olNS" -- do you see the spelling error there? Using "Option Explicit" at the top of every module will prevent simple syntax errors like this. HTH, JP On Apr 16, 7:20 pm, Greg wrote: hi, I have the following code i'm having trouble with. it appears to be in the objects set up. any help is appreciated. --------------------------------------------- Sub SaveAttachment(MyMail As MailItem) Dim strID As String Dim objNS As Outlook.NameSpace Dim objMail As Outlook.MailItem Dim objAttachments As Outlook.Attachments Dim strPath As String, strFile As String strPath = "\\ad\gbs$\Download\HM\" strID = MyMail.EntryID Set objNS = Application.GetNamespace("MAPI") Set objMail = olNS.GetItemFromID(strID) Set objAttachments = objMail.Attachments - snip - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Rule "with specific words.." and "reply with.." works inconsistent | ppi | Outlook - Installation | 2 | February 8th 08 06:01 PM |
Uncheck all Outlook categories with "run script" rule | dpresc | Outlook and VBA | 4 | February 6th 07 07:42 PM |
change incoming email attachment default to "open" vs "save as" | conroy | Outlook - General Queries | 1 | December 12th 06 01:58 AM |
"run a script" rule won't fire macro | [email protected] | Outlook and VBA | 3 | October 18th 06 06:08 AM |
"Run a script" rule triggers but script does not execute | Trey Shaffer | Outlook and VBA | 7 | April 7th 06 11:34 PM |