Normally the connection is put in a batch file.
I use rasdial to make the connection (and let it prompt the user for the password), and then run any extra goodies from the rest of the batch file, not forgetting to test the errorlevel from the connection.
Hope this helps