below is code that PHV wrote and it works great, however my users want to add a another feature, save the report as a pdf file, as it stands when the user run this fuction it ask them to select a format MS Excel...HTML ...RTF Snapshot etc.. is there a way to set the report with the pdf extension?? I'm working in Access 2000 and I do have Adobe Acrobat PDFWriter
Thanks in advance...
PHV code
Private Sub cmdEmailNew_Click()
On Error GoTo Err_cmdEmailNew_Click
'opens an e-mail with the address in a form field
DoCmd.SendObject acReport, "rptRFQResponseLetter", , [Forms]![frmCustomerRFQ]![txtEmail], , , [Forms]![frmCustomerRFQ]![txtCustNo]
Exit_cmdEmailNew_Click:
Exit Sub
Err_cmdEmailNew_Click:
MsgBox Err.Description
Resume Exit_cmdEmailNew_Click
End Sub
Thanks in advance...
PHV code
Private Sub cmdEmailNew_Click()
On Error GoTo Err_cmdEmailNew_Click
'opens an e-mail with the address in a form field
DoCmd.SendObject acReport, "rptRFQResponseLetter", , [Forms]![frmCustomerRFQ]![txtEmail], , , [Forms]![frmCustomerRFQ]![txtCustNo]
Exit_cmdEmailNew_Click:
Exit Sub
Err_cmdEmailNew_Click:
MsgBox Err.Description
Resume Exit_cmdEmailNew_Click
End Sub