Single Macro to activate multiple email send

[MagicMan]

Hi Folks,

I have six macros (Region1, Region2, Region3, Region4, Region5 and Region6). Each of those macro, extract Region specific sheets from a workbook and emails them to different people.

Each of the macros 'display' the emails before they send it. (i.e. ".display" rather than ".send"). This enables me to 'common sense' check the email prior to sending.

I'm trying to put together a macro that will run each of the macros above one after the other. I've tried setting up a macro to simply call each macro in turn, however, it seems that the .display after running "Sub Region1()" prevents it from then activated "Sub Region2()"

Ultimately I'd end up with 6 emails on display ready for me to hit the "Send" button in Outlook.

Does anyone have any ideas on how I could overcome this please?

Many thanks,

MagicMan

[TMS]

I'm surprised that the .Display is causing a pause/delay as it is in Outlook at that point. I don't see why Excel would be waiting for a response.

It would be helpful to see your code and, ideally, a sample workbook.



Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[MagicMan]

Hi Trevor,

I'll happily post the code (i'll reduce it down to three as once I've grasped the principle with 3, doing it with 6 is simple logic

Unfortunately I can't post the workbook as it contains thousands of names. I'll leave the code here for now and see if I can mock up a testing workbook (even if it's full of rubbish). Mocked workbook now uploaded (don't worry about the content). Pressing the Region buttons individually should work it's the "Send All Regions" macro that I want to get to work.

Individual Codes for Regions 1, 2 and 3 (They're basically the same code repeated)

Please Login or Register  to view this content.

I tried this to activate each macro one after the other.

Please Login or Register  to view this content.

[MagicMan]

Cracked it!

It would appear that the area of code highlighted in red bold was the culprit

Please Login or Register  to view this content.

By commenting it out, it stopped the issues I was having

[TMS]

Glad you've resolved your problem. Can't quite see how that makes a difference but, if it works, it work



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.