Can't find procedure or module to run

Status
Not open for further replies.
L

laavista

I'm using Outlook 2003. I am so frustrated and would really appreciate your

help. I have a procedure with parameters (e.g., sub NoMoreManual(myitem as

mailitem)

but I cannot figure how to run it!

I have looked in HELP and read the threads in this forum. One said that if

have parameters, it cannot be run via the RUN icon (or macros, run) and that

that you need to use run-a-script or rules wizard. I save my procedure,

then go into rules and still do not see it. I have search HELP on

run-a-script to no avail.

If I take the parameters out, then it runs, but get error messages, of course.

HELP!
 
S

Sue Mosher [MVP]

You need to provide a procedure that tells outlook which "myitem" to run this

procedure against. Something like:

Sub RunIt()

Set thisItem = <some code to return a MailItem
Call NoMoreManual(thisItem)

End Sub

We can't help you with the <some code> portion until you provide a more

complete picture of your scenario. In other words, what message do you want

to run the NoMoreManual() procedure against?

"laavista" wrote:


> I'm using Outlook 2003. I am so frustrated and would really appreciate your
> help. I have a procedure with parameters (e.g., sub NoMoreManual(myitem as
> mailitem)
> but I cannot figure how to run it!

> I have looked in HELP and read the threads in this forum. One said that if
> have parameters, it cannot be run via the RUN icon (or macros, run) and that
> that you need to use run-a-script or rules wizard. I save my procedure,
> then go into rules and still do not see it. I have search HELP on
> run-a-script to no avail.

> If I take the parameters out, then it runs, but get error messages, of course.

> HELP!
 
L

laavista

Thank you so much for responding to my question!! (I'm excited "to meet

you". I've ordered your book!)

I'm finding Outlook VBA very challenging. I've worked a lot with Access

VBA and some in Excel, but Outlook VBA is baffling.

What I'm actually trying to do (unsuccessfully I might add) is:

in a specific folder

folder contains COPIES of emails sent with attachments

go through each email and do a REPLY with different addressees

than the original email (same addressees each time, though)

and WITHOUT the attachment

then delete the email

The addressees must receive these emails without the attachments as the

attachments have limited information, but the addressees must have the

contents of the email iteself.

It sounds so easy, but ...

I was trying out different things I found in forum threads and the help

file, but immediately stumbled when I could find the procedure I just created.

"Sue Mosher [MVP]" wrote:


> You need to provide a procedure that tells outlook which "myitem" to run this
> procedure against. Something like:

> Sub RunIt()
> Set thisItem = <some code to return a MailItem
> Call NoMoreManual(thisItem)
> End Sub

> We can't help you with the <some code> portion until you provide a more
> complete picture of your scenario. In other words, what message do you want
> to run the NoMoreManual() procedure against?

> "laavista" wrote:
>
> > I'm using Outlook 2003. I am so frustrated and would really appreciate your
> > help. I have a procedure with parameters (e.g., sub NoMoreManual(myitem as
> > mailitem)
> > but I cannot figure how to run it!
> > I have looked in HELP and read the threads in this forum. One said that if
> > have parameters, it cannot be run via the RUN icon (or macros, run) and that
> > that you need to use run-a-script or rules wizard. I save my procedure,
> > then go into rules and still do not see it. I have search HELP on
> > run-a-script to no avail.
> > If I take the parameters out, then it runs, but get error messages, of course.
> > HELP!
 
S

Sue Mosher [MVP]

The simplest way to process a folder other than the one you're currently

looking at is to use the Namespace.PickFolder method to display the built-in

folder picker dialog and return the folder that the user choosers. Then, you

can process each item in the folder, for example:

On Error Resume Next

Set myFolder = Application.Session.PickFolder()

If Not myFolder Is Nothing Then

For Each itm in myFolder.Items

Call NoMoreManual(itm)

Next

End If

"laavista" wrote:


> Thank you so much for responding to my question!! (I'm excited "to meet
> you". I've ordered your book!)

> I'm finding Outlook VBA very challenging. I've worked a lot with Access
> VBA and some in Excel, but Outlook VBA is baffling.

> What I'm actually trying to do (unsuccessfully I might add) is:
> in a specific folder
> folder contains COPIES of emails sent with attachments
> go through each email and do a REPLY with different addressees
> than the original email (same addressees each time, though)
> and WITHOUT the attachment
> then delete the email

> The addressees must receive these emails without the attachments as the
> attachments have limited information, but the addressees must have the
> contents of the email iteself.

> It sounds so easy, but ...

> I was trying out different things I found in forum threads and the help
> file, but immediately stumbled when I could find the procedure I just created.

> "Sue Mosher [MVP]" wrote:
>
> > You need to provide a procedure that tells outlook which "myitem" to run this
> > procedure against. Something like:
> > Sub RunIt()
> > Set thisItem = <some code to return a MailItem
> > Call NoMoreManual(thisItem)
> > End Sub
> > We can't help you with the <some code> portion until you provide a more
> > complete picture of your scenario. In other words, what message do you want
> > to run the NoMoreManual() procedure against?
> > "laavista" wrote:
> >
> > > I'm using Outlook 2003. I am so frustrated and would really appreciate your
> > > help. I have a procedure with parameters (e.g., sub NoMoreManual(myitem as
> > > mailitem)
> > > but I cannot figure how to run it!
> > > > I have looked in HELP and read the threads in this forum. One said that if
> > > have parameters, it cannot be run via the RUN icon (or macros, run) and that
> > > that you need to use run-a-script or rules wizard. I save my procedure,
> > > then go into rules and still do not see it. I have search HELP on
> > > run-a-script to no avail.
> > > > If I take the parameters out, then it runs, but get error messages, of course.
> > > > HELP!
 
L

laavista

Thank you so much for taking the time to help me with this!

"Sue Mosher [MVP]" wrote:


> The simplest way to process a folder other than the one you're currently
> looking at is to use the Namespace.PickFolder method to display the built-in
> folder picker dialog and return the folder that the user choosers. Then, you
> can process each item in the folder, for example:

> On Error Resume Next
> Set myFolder = Application.Session.PickFolder()
> If Not myFolder Is Nothing Then
> For Each itm in myFolder.Items
> Call NoMoreManual(itm)
> Next
> End If

> "laavista" wrote:
>
> > Thank you so much for responding to my question!! (I'm excited "to meet
> > you". I've ordered your book!)
> > I'm finding Outlook VBA very challenging. I've worked a lot with Access
> > VBA and some in Excel, but Outlook VBA is baffling.
> > What I'm actually trying to do (unsuccessfully I might add) is:
> > in a specific folder
> > folder contains COPIES of emails sent with attachments
> > go through each email and do a REPLY with different addressees
> > than the original email (same addressees each time, though)
> > and WITHOUT the attachment
> > then delete the email
> > The addressees must receive these emails without the attachments as the
> > attachments have limited information, but the addressees must have the
> > contents of the email iteself.
> > It sounds so easy, but ...
> > I was trying out different things I found in forum threads and the help
> > file, but immediately stumbled when I could find the procedure I just created.
> > "Sue Mosher [MVP]" wrote:
> >
> > > You need to provide a procedure that tells outlook which "myitem" to run this
> > > procedure against. Something like:
> > > > Sub RunIt()
> > > Set thisItem = <some code to return a MailItem
> > > Call NoMoreManual(thisItem)
> > > End Sub
> > > > We can't help you with the <some code> portion until you provide a more
> > > complete picture of your scenario. In other words, what message do you want
> > > to run the NoMoreManual() procedure against?
> > > > > "laavista" wrote:
> > > > > I'm using Outlook 2003. I am so frustrated and would really appreciate your
> > > > help. I have a procedure with parameters (e.g., sub NoMoreManual(myitem as
> > > > mailitem)
> > > > but I cannot figure how to run it!
> > > > > > I have looked in HELP and read the threads in this forum. One said that if
> > > > have parameters, it cannot be run via the RUN icon (or macros, run) and that
> > > > that you need to use run-a-script or rules wizard. I save my procedure,
> > > > then go into rules and still do not see it. I have search HELP on
> > > > run-a-script to no avail.
> > > > > > If I take the parameters out, then it runs, but get error messages, of course.
> > > > > > HELP!
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
K Use VBA to find Sender and Recipient from Microsfot 365 Journaled Email Items Outlook VBA and Custom Forms 3
M How can we find the list of users who are members of a deleted distribution list? Exchange Server Administration 2
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
H Outlook 2003 find by "has attachment" Using Outlook 1
geoffnoakes Find Contacts with UDFs "in this item" Using Outlook 1
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
B Outlook 2010 Can not find a certain file in M/S Outlook 2010. Using Outlook 1
T "cannot find the calendar folder for this item" - calendar items stuck in outbox Using Outlook 0
S Find a cell value in excel using outlook vba Using Outlook 1
B Looking to filter (or just find/search) for only messages that the sender has sent more than 1 messa Using Outlook 2
B Search: Cannot find which Folder Contains a Message Using Outlook 3
K How to find specific header and copy the mail body Using Outlook 0
Hudas VBA find and open an email without looping thru each email in the inbox Outlook VBA and Custom Forms 1
E How to find or recover Lost e-mails within a folder under Inbox? Using Outlook 2
H "Advanced find: column for full folder path? Using Outlook 1
M What is the best way to find all records of an e-mail for our company? Outlook VBA and Custom Forms 2
C Find all deleted recurrence appointments Outlook VBA and Custom Forms 4
mrje1 Is there a Find and Replace feature in Outlook 2016? Using Outlook 4
G Can't find contacts entered Using Outlook 0
Connie Boyer Exporting Outlook calendar/find next repeating meeting Using Outlook 3
B Find related messages to sender Outlook VBA and Custom Forms 7
B Find Related Emails to sender Using Outlook 1
RBLampert Outlook "can't find" my e-mail server to receive messages Using Outlook 22
M Can't find messages Using Outlook 4
Diane Poremsky Find the Distribution Lists a Contact Belongs to Using Outlook 0
T Macro to find contacts by category and copy them to another folder Outlook VBA and Custom Forms 15
thomas zaleski Cannot find the Sending FOlder Using Outlook 2
J Find and Highlight text in outlook Outlook VBA and Custom Forms 4
J Outlook Mailbox cleanup; any way to change limit to find items older 999 days? Exchange Server Administration 2
F Disable "Find related messages" Using Outlook 1
Jennifer Murphy Can't delete or even find task attachment Using Outlook 1
K Re: Use Instant search to find messages from a contact Outlook VBA and Custom Forms 6
Andrew Hawkins "Advanced Find" Using Outlook 1
M BCM 2007 Can't find SS2012Express Using Outlook 2
O Outlook 2013 contacts - Where to find "Display as"-field Using Outlook 2
A Advanced find query facilty Help please Using Outlook 2
C Cant find emails after moving pst Using Outlook 1
G Find Organizer of appointment Using Outlook 2
R writing "Instant Search" queries to find User-Defined fields Using Outlook 0
P Outlook Advanced Find Using Outlook 0
S Advanced Find text field limits Using Outlook 2
C O2010: Using Advanced Find to locate exact queries Using Outlook 3
D Outlook 2007 Find All Related and Messages From Sender not working Using Outlook 3
V Advanced Find - [Today]-3 ? Using Outlook 4
S Cannot Find Shared Database on Remote Computer BCM (Business Contact Manager) 13
V rule to Find some words in the subject, change subject then forward Using Outlook 1
L Mapi folder.FIND: error Using Outlook 0
T Find the sender who sent the mail from Generic Mailbox. Using Outlook 4
S Can't find some addresses after a contact list export. Using Outlook 1
F Can't find all stationery listed in stationery picker Using Outlook 2

Similar threads

Top