Can a single workflow generate multiple list items?
2 answers
You cannot use foreach on workflows created with Sharepoint Designer (as far as I know). To complete the required steps, you will need to create a custom workflow in Visual Studio. I had to go down this route quite recently and it wasn't as bad as I expected.
There are some great videos of this process on Robert Shelton's blog that helped get me started.
If your MOSS 2007 development environment is 64-bit (like mine), then you may have problems creating and debugging workflows using Visual Studio 2008. In this case, I would recommend WSPBuilder to help you package your workflows for easy deployment in Sharepoint. There is a nice post here on using WSP Builder
Hope it helps.
+1
source to share