As macropod suggests, this would be a lot easier to do as a mail merge.

FWIW, your code has obvious errors which cause compilation errors but I can't test to iron out any other issues related to the things we can't see there.

DefaultTableBehaivor is not spelt correctly and needs to say DefaultTableBehavior
strPassword -InputBox("Password Please?", "Lock Forms Password") should have an equals sign instead of the minus

Add Dim strEmps As String, strPath As String to the start of the Sub Connect macro

Public connEmp As ADODB.Connection - this line fails to compile because you haven't added a reference to one of the Microsoft ActiveX Data Object x.x Library

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia