VBA - Move a specific number of files from one folder to another

[MonkeyDeath]

what i am trying to do is move a specific number of files from one folder to another if there is too many files in the source folder ie

source folder has 126 files all PDF's, i want to move the first 50 files into a brand new folder. then loop until there are 50 or less files in any folder.

if its possible to limit the total mb instead of file quantity then that would be better.

its driving me mad

[mikeTRON]

Why are you wanting to only do 50 at a time?

[MonkeyDeath]

Its part of a bigger script that emails the files in the folder, after creating a list of whats in the folder. its a way of limiting the email size. the files will generally be a maximum 500kb, mostly 200-230kb each. but if i could limit on total folder size to 10mb or a bit smaller, then that would work too.

i have a code which copys all the PDF's in a folder picked by the user, it lists all the files, adds some other text etc. But people are starting to send 100+ files, and at about 30mb for the email, gets very big, they just dont understand to split the files up into different folders, etc.

basically i will loop this to create multiple emails until all the files are in emails.

[MonkeyDeath]

Any Help?

Please