Hi Karin,
Would you be able to upload a sample of your db that includes the tblAuthorizerLetterFinal table (no sensitive data, just one or two dummy records) and a copy of the Word template)?
I would suggest you try a CSV delimited export first; I think what you need is to set the last parameter in the TransferText to True (HasFieldNames), so please try this:
Code:
strMailMergeFileName = "M:\AADL\Authorizer\Authorizer Database TEST\Exports\MailMerge\temp.txt"
'DoCmd.TransferText acExportDelim, "Export Specification", "tblAuthorizerLetterFinal", strMailMergeFileName, False
DoCmd.TransferText acExportDelim, , "tblAuthorizerLetterFinal", strMailMergeFileName, True
Set appWord = CreateObject("Word.Application")
Set docLetters = appWord.Documents.Open("M:\AADL\Authorizer\Authorizer Database TEST\Letter Templates\Authorizer - Approved.docx")
' execute mailmerge
docLetters.MailMerge.OpenDataSource Name:=strMailMergeFileName, _
ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, Revert:=True, AddToRecentFiles:=False
Cheers,