Email Form

[leighms]

Hi

I currently have a form that staff complete and email. I have set up a query that collects the data from the form and report as well. I have added a button to the form that staff click on and it emails the report from the data just entered on the form. Currently it emails in a TXT format, however I would prefer a PDF or Word format, but cna't seem to get it to work, any suggestions?
Code for the button at the moment;
Private Sub Command55_Click()
DoCmd.SendObject acSendReport, "RptQuery12", ".txt", "email address", , , "Report Ref", "Report Ref", False
End Sub

 

[vbaInet]

What version of Access are you using?

 

[leighms]

Hi
Access 2007

 

[vbaInet]

Look into DoCmd.OutputTo

You can use that command to e-mail reports as pdf docs.