Let Connect = "driver={sql server};server=SERVERNAME;Database=DBNAME;UID=USRI D;PWD=PASSWOOD;"

This is how the above reads.
This is a script I met in place and wanted to tweak it.

I am trying to connect to a database and pull data from the field (usp_WordMerge_SelAddlinesByFileNumber) in the database.

Cmd1.Parameters(1).Value = "0947000" is suppose to represent the customer number but I am not sure how to make that happen. The field name is actually {CustomerID}

I am creating a loop to search all customerIDs and insert text in a bookmark until the customerID has no value or data.

I hope that make sense