How many subs can run in one outlook VBA script

[project Manager]

I would like to run a script (that you already helped me with) to send Email information to Trello. I would also like to send a copy of that same information to an Excel Spread Sheet which I managed to do with some slight modifications of one of your sample scripts. My question is how do I run them both on the same message as it arrives? Do I put them inside the same script and if so do I end Sub and start the second Sub?Attached is a copy of both my Modules.

 

[Michael Bauer]

There's no limit, and there's a lot of ways to accomplish it. This is one:

public sub CallThisByYourRule(mail as mailitem)
   script_one mail
  script_two mail
end sub

private sub script_one(mail as mailitem)
end sub

private sub script_two(mail as mailitem)
end sub

 

[project Manager]

There's no limit, and there's a lot of ways to accomplish it. This is one:

public sub CallThisByYourRule(mail as mailitem)
   script_one mail
  script_two mail
end sub

private sub script_one(mail as mailitem)
end sub

private sub script_two(mail as mailitem)
end sub

Nice. Thanks. I'll give it a try... Were you able to answer the two minor issues I have with my private subs?
Excel works but I need to grab the CC# at the top and haven't been able to do it inside the current pattern...
And I'm not sure how you make these apply to all emails in a folder instead of just the one that is selected.

 

[Michael Bauer]

I'm sorry, same answer here: What are you referring to?

 

[project Manager]

At the beginning of this thread I included two scripts that I'm running. inside the documents are an issues at the top.

 

[Diane Poremsky]

Assuming both scripts work individually, use the example Michael posted with 3macros. One macro is called by a rule an it calls macro1. When macro1 is finished, it goes back to the original macro and runs macro2.

You could put both together in one macro, but using two can be less confusing and allows you to run them separately, if needed.

If you need to share variables, you can do that too.

public sub CallThisByYourRule(mail as mailitem)
' run this macro first
script_one mail
' when the macro above is finished, return and run the second macro.
script_two mail
end sub
private sub script_one(mail as mailitem)
end sub
private sub script_two(mail as mailitem)
end sub