Full Version: Sending information in a form to a Word document
UtterAccess Discussion Forums > Microsoft® Access > Access Q and A
Indygirl
I have created a form to enter information, that I would like to send to a Microsoft Word document and
have it save to a specific folder. I have tried using the Output to command but it is not functioning
correctly.

I am a intermediate user - is there something I need to do differently besides the Output to command?

Thank you!!
seb
Did you set the way you want it to output as Text?
Indygirl
Yes
Larry Larsen
Hi
Could you post all your code used to send this infomation..?
thumbup.gif
Indygirl
Private Sub Command37_Click()
On Error GoTo Err_Command37_Click

Dim stDocName As String

stDocName = "Word document output"
DoCmd.RunMacro stDocName

Exit_Command37_Click:
Exit Sub

Err_Command37_Click:
MsgBox Err.Description
Resume Exit_Command37_Click

End Sub

Is this what you mean? It will open word and take the data field names that I want but it will not take the data associated. Thank you. shrug.gif
Larry Larsen
Hi
Would really need to know what the macro is doing..
Are you creating a new doc or editing an existing one..?
thumbup.gif
Peppie
Try this example database.....

Peppie
Indygirl
I am creating a new doc -
I have it taking the data over now Finally!!
However, is there a reason it will not take the logo picture as a part of the report?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.