Running Files from Multiple Folders

[Rambo-X]

Hello Everyone,

This was given to me by Steve related to a previous Question.

1 | FOR | EACH | FILE IN | D:\Macro\macro_folder | DO
2 | FOR | EACH | LINE IN | %FILE% | RUN
3 | FOR | NEXT

This helps me to run a set of mmmacro files one after the other from a specific folder.

But now I have stumbled upon a more complex scenario.

Let me explain what I Have, what I Run and what I need your help on.

What I Have :

Folder 01. Individual email addresses ( txt files - multiple )
Folder 02. A set up change ( mmmacro files - multiple )
Folder 03. The Set up ( only 02 mmmacro files : before and after files )

What I Run :

I have a Macro which runs in below sequence.

Line 01. Mmmacro file ( from Folder 03. ) -
runs what happens before we enter email. ( some clicks to get things in place )

Line 02. Mmmacro file ( from Folder 03. ) -
to pick the email from Folder 01. And paste it.

Line 03. Mmmacro file ( from Folder 03. ) -
runs what needs to happen after pasting the email.

This is replicated again and again for over 700 lines to pick various emails IDs I need. So the code goes 3 lines by 3 lines and only the line 2 changes to pick that respective email. address.

But in some scenarios, I need to switch on an Extension in the browser like after every 5 emails sent (every 15 lines) , or 10 emails sent (every 30 lines) etc. So I have to always insert that mmmacro code to this line depending requirement.
And that code is taken from Folder 02. And that has around 50 files as well.

What I Need :

Taking the Solution for "Each File in Folder" can something like below be done to tackle the issue at hand.

What my requirement would be in sequence.

01. Read the Macro and Execute what happens before pasting email address.
02. Paste the email address by "Each File in Folder" system not having to be specific.
03. Read the Macro and Execute what happens after we have pasted the email.
04. The above to go on loop.
05. A variable to be assigned like lets say for the set up change, after like every 5 emails sent, or every 10 emails sent run the macro from Folder 2 and this should also keep going not according to number of files in its folder but on a sequence reading each set up file (as said previously I got around 50) from its folder until the above loop stops.( So in a given scenario not all files in it may run, because we may not have so many emails to be sent).
06. The above to go on loop until first loop ends.

Therefore emails would go according to the number of txt files in the Folder 01. And the Variable will decide after how many emails should it launch the broswer extension.

Thanks a lot again for all of you.

[Rambo-X]

And also,

Please be kind enough to let me know if we could also control the number of emails sent from Point No. 03 onwards via a variable as well. So that I may not have to physically remove the emails.

Meaning even though I want this Macro to run depending on number of files, can we also control it via a variable to put a stop if we want to.

[philranger]

I hope I’m not helping a spammer, but...

I would either create a copy from all these files into the same folder, or even better, just extract all of their content in a single text file to read from. To do so, open a Windows Explorer and navigate to the folder you want. Then, in the address bar, type « cmd » and hit enter. In the black window that opens, type your dos command (example: copy /b *.txt newfile.txt). Repeat for your 3 folders, then work from there.

[Steve]

Feb 24, 2021 8:32:23 GMT Rambo-X said:

What I Need :

Taking the Solution for "Each File in Folder" can something like below be done to tackle the issue at hand.

What my requirement would be in sequence.

01. Read the Macro and Execute what happens before pasting email address.
02. Paste the email address by "Each File in Folder" system not having to be specific.
03. Read the Macro and Execute what happens after we have pasted the email.
04. The above to go on loop.
05. A variable to be assigned like lets say for the set up change, after like every 5 emails sent, or every 10 emails sent run the macro from Folder 2 and this should also keep going not according to number of files in its folder but on a sequence reading each set up file (as said previously I got around 50) from its folder until the above loop stops.( So in a given scenario not all files in it may run, because we may not have so many emails to be sent).
06. The above to go on loop until first loop ends.

Wow Rambo-X this is pretty busy. I don't think I'm following on quite right. Can you break your problem down a little further? Sometimes it helps to address one issue at a time.

Your question is good timing though. I am working on some email functions with MMM right now for the next version. I'm almost done. I've got the code down I just need to write a GUI for it for the condition page:
1 | RUN ACTION | SEND EMAIL | SETUP::C:\the\file\path\mail_setup.txt
2 | RUN ACTION | SEND EMAIL | SEND::FROM=[e-mail]::TO=[e-mail]::SUBJECT::MMM - email test::HTML=FALSE::FILE=c:\the\file\path\mailsend_body.txt
SETUP - will load in the SMTP mail settings
SEND - will send the the email body.

I have some variations of the commands.

The next release, if you don't mind sending emails from MMM, will probably change the solution to your email scripts.

[Rambo-X]

Hi Philranger,

 Nope...Not involved into any way of spam here. OMG.   It's to get send some unique set of numbers to get them a code.

Anyways I didn't understand your solution. I am not that good with dealing within the cmd prompt.

[Rambo-X]

Hello Steve...

Apologies for my late Response.

I don't allow you to catch a break huh....      hahaha.
I hope you are in good health and safe.

Okay let me explain it further with some examples



What I Have :



Folder 01.

Individual email addresses ( txt files - multiple )


Example : Cus-0001.txt, Cus-0002.txt, Cus-0003.txt ( Holds a single email address )

    Note :     It doesn't always have to be the case though, because I will refer to this note later on why I use one text file at a time for each customer. I wouldn't mind All respective Customer Emails to be in one Txt file, but prefer if they are as they are which are stored in separate txt Files.

Folder 02.

Proof ( mmmacro files - multiple )


Example : Screenshot-0001.mmmacro, Screenshot-0002.mmmacro, Screenshot-0003.mmmacro

    Note :     This is an extension I wake from the browser to capture a proof that I have generated and sent the requested codes to our Customer Groups. I don't want an alternative to this. This codes are different to one another due to the email bodies and details we capture.


Folder 03.

The Set up ( mmmacro files - multiple : before and after files )



Example :

Presend.mmmacro - Does the work required before pasting the Email Address
Postsend.mmmacro - Does the work required after pasting the Email Address


Folder 04. 

Customer Email Copy and Paste Purpose ( mmmacro files - Multiple )

Paste-Cus-0001.mmmacro - Copies and Pastes the email address of Cus-0001 from Cus-0001.txt
Paste-Cus-0002.mmmacro - Copies and Pastes the email address of Cus-0002 from Cus-0002.txt
Paste-Cus-0003.mmmacro - Copies and Pastes the email address of Cus-0003 from Cus-0003.txt
.
.
.
.
.

What I Run : ( For purpose of keeping things simple I have not mentioned the Folders I pull the macros from )




1 | RUN ACTION | RUN MACRO INLINE | C:\work\Presend.mmmacro

2 | RUN ACTION | RUN MACRO INLINE | C:\work\Paste-Cus-0001.mmmacro

3 | RUN ACTION | RUN MACRO INLINE | C:\work\Postsend.mmmacro

4 | RUN ACTION | RUN MACRO INLINE | C:\work\Presend.mmmacro


5 | RUN ACTION | RUN MACRO INLINE | C:\work\Paste-Cus-0002.mmmacro


6 | RUN ACTION | RUN MACRO INLINE | C:\work\Postsend.mmmacro

7 | RUN ACTION | RUN MACRO INLINE | C:\work\Presend.mmmacro


8 | RUN ACTION | RUN MACRO INLINE | C:\work\Paste-Cus-0003.mmmacro


9 | RUN ACTION | RUN MACRO INLINE | C:\work\Postsend.mmmacro

* | Screenshot 01

10 | RUN ACTION | RUN MACRO INLINE | C:\Proof\Screenshot-0001.mmmacro

* | Screenshot 01

11 | RUN ACTION | RUN MACRO INLINE | C:\work\Presend.mmmacro



12 | RUN ACTION | RUN MACRO INLINE | C:\work\Paste-Cus-0004.mmmacro



13 | RUN ACTION | RUN MACRO INLINE | C:\work\Postsend.mmmacro



14 | RUN ACTION | RUN MACRO INLINE | C:\work\Presend.mmmacro



15 | RUN ACTION | RUN MACRO INLINE | C:\work\Paste-Cus-0005.mmmacro



16 | RUN ACTION | RUN MACRO INLINE | C:\work\Postsend.mmmacro



17 | RUN ACTION | RUN MACRO INLINE | C:\work\Presend.mmmacro



18 | RUN ACTION | RUN MACRO INLINE | C:\work\Paste-Cus-0006.mmmacro



19 | RUN ACTION | RUN MACRO INLINE | C:\work\Postsend.mmmacro

* | Screenshot 01



20 | RUN ACTION | RUN MACRO INLINE | C:\Proof\Screenshot-0002.mmmacro



* | Screenshot 01


.
.
.

    Note :     ( It doesn't always have to be the case though, because I will refer to this note later - is now explained ) If you look at the above code, you'd realize it's the same code which is repeating except the Paste-Cus-xxxx Code & the screenshot Code. Therefore from a previous solution you had given me, I dissect all Customer contacts to individual text files ( on how ever the sequence I want ) and call them and paste them between Presend.mmmacro & a Postsend.mmmacro, and then the biggest issue I have is to keep deleting the Screenshot lines and apply them again and again if my next Clientele needs proof from let's say 6 by 6, 9 by 9, or 20 by 20 which can get extremely tiresome if they are like a team of 200 or above and on a specific day if I have to send this to around different 30+ teams.
.
.
.

What I Need :



Taking the Solution for "Each File in Folder (preferable ) over Each Line in File" can something like below be done to tackle the issue at hand.



What my requirement would be in sequence.



01. Let's say I have 03 Components and 02 points of Variable feeds to control the Macro.
       
        Components at hand would be : ( a, b & c ) | Variable feeds I would want to manually control would be ( b & c ) 

        a. Number of all Customers in the Group ( Ex : 100 )
        b. Number of x by x for Proof ( Ex : 3 by 3 )
        c. Number of Customers I actually have to send Emails ( Ex : 50 ) - Lets call them Top performers

02. So assuming I would only need to send emails to the Top 50 performers - assuming I dissected the Cus-0001 to Cus-0050 to be the Top performers,

03. The Main-Macro sends emails via the above setup files and after every 3 emails which are sent, it runs only one screenshot macro file in sequence from Screenshot Folder. ( Screenshot-0001.mmmacro, Screenshot-0002.mmmacro, Screenshot-0003 etc.)

04. The above goes on loop until the number of customers required to send emails in the Batch is met which is 50 in this Example.
    
    Note :    Varieties of Screenshots are like 10, and it could keep going on a loop as far as required.


Thanks a lot again to all of you.

Have a Great Day.

[Steve]

Mar 1, 2021 5:49:24 GMT Rambo-X said:

What I Need :

Taking the Solution for "Each File in Folder (preferable ) over Each Line in File" can something like below be done to tackle the issue at hand.

What my requirement would be in sequence.

01. Let's say I have 03 Components and 02 points of Variable feeds to control the Macro.
       
        Components at hand would be : ( a, b & c ) | Variable feeds I would want to manually control would be ( b & c ) 

        a. Number of all Customers in the Group ( Ex : 100 )
        b. Number of x by x for Proof ( Ex : 3 by 3 )
        c. Number of Customers I actually have to send Emails ( Ex : 50 ) - Lets call them Top performers

02. So assuming I would only need to send emails to the Top 50 performers - assuming I dissected the Cus-0001 to Cus-0050 to be the Top performers,

03. The Main-Macro sends emails via the above setup files and after every 3 emails which are sent, it runs only one screenshot macro file in sequence from Screenshot Folder. ( Screenshot-0001.mmmacro, Screenshot-0002.mmmacro, Screenshot-0003 etc.)

04. The above goes on loop until the number of customers required to send emails in the Batch is met which is 50 in this Example.
    
    Note :    Varieties of Screenshots are like 10, and it could keep going on a loop as far as required.

Okay...so really you need some help with loop control?  You've got a lot of macro files your calling here so I'm assuming your ok with some of the basic FOR syntax. 

The search function of this forum is pretty good.  Have a look here for some loop examples from this forum. 

I have to level with you Rambo-X...I don't really have the time at the moment to work through the detail you've posted.  Sorry about that.  Is there anyway you can break down your issue into something easier to digest?