Transferring form data into notepad

barretc

Registered User.
Local time
Today, 05:25
Joined
Jul 14, 2006
Messages
14
Hey,

I am trying to code a button which, upon clicking it, copies the information currently in the form into notepad.

So far I have successfully coded a way to put it into an email. I was just wondering if the above solution would look something like this, or would it be completely different

-=============================================-

Private Sub Command235_Click()
Dim strToWhom As String
Dim strMsgBody As String
Dim strSubject As String



strSubject = "Your Subject goes here!"
strToWhom = "support@xxxxx.x"


strMsgBody = "Call No: " & Call_No & Chr(10) & _
"Date: " & Date & Chr(10) & " " & "Customer Name: " & Customer_Name & Chr(10)



DoCmd.SendObject , , , strToWhom, strToCCWhom, , strSubject, strMsgBody, True

End Sub

-=============================================-

So far I have found out how to open notepad:

Private Sub Command244_Click()

Shell ("notepad.exe ")
End Sub

Hooray.

Thanks.
 

Users who are viewing this thread

Back
Top Bottom