Hi, I'm having issues trying to get the following simple SELECT to run as part of a word mail merge using vba .
UserName = (Environ$("Username"))
sDBPath = "U:\" & UserName & "\db.accdb"
SQL = "SELECT * FROM [TestName] T INNER JOIN [TestNameData] D ON T.TestNameId = D.TestNameId"...