Seems like this post I made earlier is just for you:
1. Download CM through Rom Manager
2. Extract zip to anywhere on your computer (CM zip should be in /sdcard/clockworkmod/downloads/koush.romraid.com/motorola/sholes
3. Download Passion Pack
4. Open Passion Pack with WinRAR and navigate to /system/app and extract wanted apks to the computer.
5. Inject wanted apks into CM zip in the /system/app directory.
6. Move modified CM zip back to the clockwork directory as stated in step 2
7. Install
8. ???
9. Profit.
This also works if you want to push files from your sdcard instead of from your computer, and you're needing a file manager like Root Explorer or autostart.apk--you can just put whichever apk into /system/app in whatever ROM you're about to install, and root explorer (for example) will be installed as part of the ROM itself, so you won't need to be hooked up to your computer/need internet to push files. This method essentially gets rid of the need to use adb for the wap/mms part, as root explorer also allows you to set permissions.
@New2Game: In short, just download whatever apk you're needing to have beforehand and inject it into the ROM zip you're about to install in /system/app. The apk will install itself when you install the zip.