Poobear1929
Technical User
I was wondering if anyone knew how to make a report open in word, using a word template I designed. I have a report that is sent to Outlook as an attachment as a Word Doc. However, I want it to open up in as specific layout. For instance I want my company's letterhead to appear, and I want bullet formatting. Here is a copy of the coding that I already use. I didn't design this database someone else did a long time ago and my Bose want to add this functionality. Any help someone can give me would be great.
Private Sub Command76_Click()
On Error GoTo Err_Command76_Click
Dim stDocName As String
stDocName = "StdByLtr"
DoCmd.SendObject acReport, stDocName, acFormatRTF, , , , "A/C Flight After Hours Standby", "See attachment for A/C Flight Weekly After Hours Standby Coverage."
Exit_Command76_Click:
Exit Sub
Err_Command76_Click:
MsgBox Err.Description
Resume Exit_Command76_Click
End Sub
Thank you
Poobear1929
Private Sub Command76_Click()
On Error GoTo Err_Command76_Click
Dim stDocName As String
stDocName = "StdByLtr"
DoCmd.SendObject acReport, stDocName, acFormatRTF, , , , "A/C Flight After Hours Standby", "See attachment for A/C Flight Weekly After Hours Standby Coverage."
Exit_Command76_Click:
Exit Sub
Err_Command76_Click:
MsgBox Err.Description
Resume Exit_Command76_Click
End Sub
Thank you
Poobear1929