Actually I have a data report of invoice. At present the invoice is taken as print out from that report and send that hard copy to the clients by post. But i need to send that invoice in mail. Any possibilities for that?
Private Sub Command1_Click()
' Create a simple PDF file using the mjwPDF class
Dim objPDF As New mjwPDF
' Set the PDF title and filename
objPDF.PDFTitle = "Test PDF Document"
objPDF.PDFFileName = App.Path & "\myreport.pdf"
' We must tell the class where the PDF fonts are located
objPDF.PDFLoadAfm = App.Path & "\Fonts"
' View the PDF file after we create it
objPDF.PDFView = True
' Begin our PDF document
' Set the font name, size, and style
objPDF.PDFSetFont FONT_ARIAL, 15, FONT_BOLD
' Set the text color
objPDF.PDFSetTextColor = vbBlue
' Set the text we want to print
objPDF.PDFTextOut ***"Quotation Manager Report"***
' End our PDF document (this will save it to the filename)
this is the above code i got but it just the working string to write in pdf and save but merely i want the whole bucket to get the datareports converted in pdf format to send through email