Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using a macro and runcode to run a sub

Status
Not open for further replies.

travismallen

Programmer
Aug 5, 2003
15
US
How do I run NewHireEmail.OutlookPump with the runcode macro action? NewHireEmail is the module name and OutlookPump() is the Sub's name. Do I need to create a new function to do this? if so, how? Thx!

___________________________
"I am what I am" - Popeye
Travis M. Allen
 
travismallen . . .
Yes! create a function in a module that calls OutlookPump():
Code:
[blue]Public Function [purple][b][i]FunctionName[/i][/b]()[/purple]
   Call OutlookPump
End Function[/blue]
. . . and set Function Name in the macro to [purple]FunctionName()[/purple]


Calvin.gif
See Ya! . . . . . .
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top