App.Path in Word ?

[jandrade15]

ok on that it gives me a message box telling me where the db is located. but doesnt continue the macro. ill attach the word form and the db so you can see what the default macro does..... it basically runs the mailmerge when you open the word template. like i said before its hardcoded to the c drive etc..... And i want it to find the db where ever it is located.....

What you have is on the right spot just want to automated so the box doesnt show and continues to run the macro... here is all the stuff...

Thanks a million for the help!