Using a macro/runcode to run a Sub

[travismallen]

I have a module named "NewHireEmail" and a sub named "OutlookPump()". Can someone help me with the code for a function that runs this sub?

I think I need to use something like...

Call DoCmd.OpenModule(NewHireEmail, OutlookPump())

Not sure if the module and sub names need quotes though...

thx



___________________________
"I am what I am" - Popeye
Travis M. Allen

http://www.trav-ism.com

 

[PHV]

Why not simply this ?
OutlookPump

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[travismallen]

There are 3 modules and all have a sub named "OutlookPump" but they do different things so I need to specify which one.

I also read macros can't run subs and that I'd need to make a function that calls it.

___________________________
"I am what I am" - Popeye
Travis M. Allen

http://www.trav-ism.com

 

[PHV]

NewHireEmail.OutlookPump

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[travismallen]

Do I put this in a new function or directly in Function Name for runcode in my macro?

___________________________
"I am what I am" - Popeye
Travis M. Allen

http://www.trav-ism.com

 

[PHV]

You asked in a VBA forum, so I posted VBA code.
I personally don't play with macro.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[travismallen]

Still a great help thanks!

___________________________
"I am what I am" - Popeye
Travis M. Allen

http://www.trav-ism.com