I am new to VBA and am actually copying/modifying an old Access (Pre 2016version) module VBA procedure into a new Database (2016), modifying the links. I have checked the paths and think those are correct, but I am getting errors. The purpose of the procedure is to open a word document and autofill to bookmarks with information from forms. The first error is a compile error, user-defined type, not defined. This is occurring on the second line, Dim wApp As Word.Application. I have not taken it further but imagine I will see issues. What should I be doing different?
Option Compare Database
Option Explicit
Public Sub ExportKaiserReferralForm2022()
Dim wApp As Word.Application
Dim wDoc As Word.Document
Dim rs As DAO.Recordset
Set wApp = New Word.Application
Set wDoc = wApp.Documents.Open("U:\WC Files\Pre Employment\Access\New Database\Modules\KasierReferralForm2022")
If Not rs.EOF Then rs.MoveFirst
Do Until rs.EOF
wDoc.Bookmarks("Clinic").Range.Text = Nz(rs!Clinic, "")
wDoc.Bookmarks("Date_Input").Range.Text = Nz(rs!Date_Appt_Sent_To_Clinic, "")
wDoc.Bookmarks("Name").Range.Text = Nz(rs!Name, "")
wDoc.Bookmarks("Street_Address").Range.Text = Nz(rs!Street_Address, "")
wDoc.Bookmarks("City").Range.Text = Nz(rs!City, "")
wDoc.Bookmarks("Zip_Code").Range.Text = Nz(rs!Zip_Code, "")
wDoc.Bookmarks("Phone_Contact").Range.Text = Nz(rs!Phone_Contact, "")
wDoc.Bookmarks("DOB").Range.Text = Nz(rs!DOB, "")
wDoc.Bookmarks("Job_Title").Range.Text = Nz(rs!Job_Title, "")
wDoc.SaveAs2 "U:\WC Files\Pre Employment\Access\New Database\Modules\Test\Kaiser\" & rs!ID & rs!Name & "_KasierReferralForm2022"
wDoc.Bookmarks("Clinic").Range.Delete wdCharacter, Len(Nz(rs!Clinic, ""))
wDoc.Bookmarks("Date_Input").Range.Delete wdCharacter, Len(Nz(rs!Date_Appt_Sent_To_Clinic, ""))
wDoc.Bookmarks("Name").Range.Delete wdCharacter, Len(Nz(rs!Name, ""))
wDoc.Bookmarks("Street_Address").Range.Delete wdCharacter, Len(Nz(rs!Street_Address, ""))
wDoc.Bookmarks("City").Range.Delete wdCharacter, Len(Nz(rs!City, ""))
wDoc.Bookmarks("Zip_Code").Range.Delete wdCharacter, Len(Nz(rs!Zip_Code, ""))
wDoc.Bookmarks("Phone_Contact").Range.Delete wdCharacter, Len(Nz(rs!Phone_Contact, ""))
wDoc.Bookmarks("DOB").Range.Delete wdCharacter, Len(Nz(rs!DOB, ""))
wDoc.Bookmarks("Job_Title").Range.Delete wdCharacter, Len(Nz(rs!Job_Title, ""))
rs.MoveNext
Loop
wDoc.Close False
wApp.Quit
Set wDoc = Nothing
Set wApp = Nothing
Set rs = Nothing
End Sub

