Hello Geoff,
I do this, I would like to help you. I will attach my code for you to
look at.
Private Sub Mailto_Click()
On Error GoTo Err_Mailto_Click
Dim stToWhom As String
stToWhom = DLookup("Email", "Technician", "Name = '" &
Forms!Call_ticket!sbfrmTechTime!Technician & "'")
stDocName = "CallTicketHard"
gService_Tag_No = Service_Tag_No
DoCmd.SendObject acSendNoObject, "CallTicketHard", acFormatRTF, stToWhom, , , _
"SYO's Automated Service Call Notification System", _
"You have been assigned Call Ticket #:" & Forms!Call_ticket!Service_Tag_No & ", " _
& vbCrLf & "with Service Type: " _
& Forms!Call_ticket!Type_Support & "." & vbCrLf & "This task is scheduled for " _
& Forms!Call_ticket!sbfrmTechTime!Date & " at " &
Forms!Call_ticket!sbfrmTechTime!Arrival_Time & "." & vbCrLf & vbCrLf & _
"Please call " & Forms!Call_ticket!Real_Name & " at " &
Forms!Call_ticket!CompanyName & " in the morning on " &
Forms!Call_ticket!Installation_Date & _
" at " & Forms!Call_ticket!Phone_Number & " and let him/her know when you expect
to be there." & vbCrLf & vbCrLf & _
"Additional Information: " & vbCrLf & vbCrLf & _
Forms!Call_ticket!Problem, False
Exit_Mailto_Click:
Exit Sub
Err_Mailto_Click:
MsgBox Err.Description
Resume Exit_Mailto_Click
End Sub
Thursday, April 15, 2004, 5:59:28 PM, you wrote:
GL> Using The Bat! v1.62i on Windows XP 5.1 Build 2600 Service Pack 1
GL> I have an Access database that contains customer details, which
GL> includes dates on which subscriptions are due. I contact most
GL> customers via e-mail. With other mail clients (e.g. Outlook) I've been
GL> able to use MAPI from within Access, WScript, etc. to create and send
GL> messages automatically and store copies of the sent messages in the
GL> Sent folder for the appropriate account. However, I fall over at the
GL> first hurdle with TB as the default MAPI client. For example, in VBA:
GL> Dim objMAPI As Object
GL> Set objMAPI = CreateObject("MAPI.Session")
GL> causes a run-time error because ActiveX can't create the object.
GL> So is it possible to use OLE Automation / ActiveX to "drive" TB in
GL> this way? If so, do I need to upgrade to 2.x to get that
GL> functionality?
GL> TIA,
--
Best regards,
Jason Gottschalk mailto:[EMAIL PROTECTED]
SYO Computer Engineering Services, Inc.
586-286-2557
________________________________________________________
http://www.silverstones.com/thebat/TBUDLInfo.html
