mthomas.co.uk - IT Tips, Tricks & Tutorials

A question arose today about entering random text into a Word document. You probably know that if you type =Rand() into a Word document you get 3 paragraphs each containing 5 sentences where each sentence is “The quick brown fox jumps over the lazy dog”

And if you type =Rand(X,Y) where X and Y are numbers, you get X paragraphs of Y sentences each where sentence is “The quick brown fox jumps over the lazy dog”. For example =Rand(8,10) will generate 8 paragraphs where each paragraph contains 10 sentences.

Well in Word 2007 you now have =Lorem() Read More

Last year I wrote found a piece of VBA code (well I did find it but then adapted it so back to my original comment - I wrote a piece of VBA code) that split a Word mail merge output document (i.e. the one that is produced as a result of running a mail merge) into seperate files which could then be emailed to the recipients.

Well yesterday one of my colleagues asked me to dig out the code and apply it to his mail merge - and he’d make me a cup of his famous coffee if I could do it.

So 20 minutes later and with a few changes to the code, the job was done and I was sat back with a mug of steaming coffee.

And the code…You’ll find a downloadable zip file here.