Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to open a report in Word using a Word Templet

Status
Not open for further replies.

Poobear1929

Technical User
May 11, 2004
32
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top