I need to automate as much as possible a MS Word process for a client, I am pretty good with macro's but cannot get to do exactly what I need so I suspect its more VB based than basic macro. OK, what I need the macro to do ......in Word 2002/2003 1. Opens a new document based on a named template. 2. Initiates the mailmerge helper 3. Step 1 of 6 - selects Letters 4. Step 2 of 6 - use current document 5. Step 3 of 6 - selects the odbc datasource which will be installed on the clients PCs 6. Edits the datalink properties, sets the initial catalog to blank 7. Macro stops there enabling the client to select which records to merge and print - can this have a message popup explaining what the client has to do? 8. Step 4 of 6 - the actual insertion of fields will be done in the template already 9. Step 5 of 6 - preview - message pops up to advise the client that the merge will shortly take place, ensure paper is in the printer etc 10. Print - popup the printer dialogue box to allow the client to select the relevent printer. I will supply the provider selected with the word document to be used as the template and details on the odbc connection (uses mySQL so please ensure you already have mySQL ODBC connection 3.51 installed) Is this possible? If so lets get started! Any questions via PM please.