var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Emailing a report? Please help
I have a report which includes a customers email address as a record.
I want to on clicking a certain button have this report emailed to the email address on the report plus another person.....
I have tried sendoutput to??? but can't get the email address picked up....
Also when I did get an email (though customer email not there) I used rich text and lost all of my pictures, lines????
Any help with these would be greatly appreciated
To send attachment as a snapshot file.
DoCmd.SendObject acReport, stDocName, "SnapshotFormat (*.snp)", Me.txtEmailAdd, , , strSubject, strMsg
stDocName = Report Name
Me.txtEmailAdd = Email Address
strSubject = Subject
strMsg = Email Message
Last edited by Cosmos75; 08-25-04 at 02:09.
What if I want to use a command line utility like blat to send the email. How would I create a snapshot file to attatch to the email?
you would create a temp snapshot file on the harddrive with outputto action and attach it I guess?
Originally Posted by ottomatic
Last edited by ghozy; 09-30-04 at 14:27.
Try the following,
Dim stDocName As String
stDocName = "test Report"
DoCmd.SendObject acSendReport, stDocName, acFormatRTF,'to name','cc name', , "title of report on subjectline of email."
refer the sendobject Method for more details:
DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]
You can write the above code on the click event of the command button.
Last edited by skodidhi; 09-30-04 at 14:28.