Solved: report to pdf and email

[nepotist]

I am trying to save a report as pdf and email it .
the code that I am using it is the following
[VBA]Private Sub Command4_Click()
'DoCmd.OpenReport "qryEncumberedProjectReport", acViewPreview
'DoCmd.OutputTo acOutputReport, "Test", acFormatPDF, "C:\Documents and 'Settings\vvishwanatha\My Documents\CMS\" & "test" & ".pdf"

DoCmd.SendObject acSendReport, "qryEncumberedProjectReport", acFormatPDF
End Sub
[/VBA]
it gives me a error 2282, saying that the format in which you are attempting to output the current object is not available.
I then downloaded the pdf extension but still find the same error.

I am using access 2007
I have done some search online and read at one place saying that this cannot be done in 2007, as this is bug.

any one can help me to work this

Thank you

[Carl A]

I have done some search online and read at one place saying that this cannot be done in 2007, as this is bug.

I have no problem with this I'm running 2007 SP1

[nepotist]

well i am getting the above mentioned error.
What should I do then and I dont know what is the service pack that i am running though and i dont think the service pack should matter

Any one any clue ???

[ottoS13]

couldnt add the link, but go to this
support.microsoft.com/kb/934833

you'll need the addins at the bottom, unsure if you have them already or if they're in office 2007 sp1

[nepotist]

I solved it man... I think these days it is the problem with the adobe pdf. I did run the whole thing on a machine that had foxit software (another one similar to view pdf) it works like a charm
Thanks for ur response though9 I tried them but still it dint work