sending report looks awfull

[Jean-Paul]

Now I send my report with following code

SubjectBox = "Aanpassen database SALES met nieuwe input voor klanten van
" & Forms!Hoofdmenu!Tekst24
MessageBox = ""
DoCmd.SendObject acSendReport, "Fiche", acFormatHTML, ontvanger, , ,
[SubjectBox], [MessageBox], -1

But.... it doesn't look nice.
Changing acFormatHTML into acFormatTXT doesn't look much better...

It would be nice to send it as a doc or as a pdf file

Can this be done?

Thanks

 

[Dale Fye]

What version of Access are you using? If A2007, then use acFormatPDF. I
think Steve Lebans has something on his website at:
http://www.lebans.com/reporttopdf.htm that might be useful if you don't have
2007.

Another option would be to use OutputTo, and use the PDF format to output
the report to a file, then send it as an attachment using Outlook
automation.

Dale

 

[Jean-Paul]

could you please explain the OutputTo option a bit more please?
Thanks
JP

What version of Access are you using? If A2007, then use acFormatPDF. I
think Steve Lebans has something on his website at:
http://www.lebans.com/reporttopdf.htm that might be useful if you don't have
2007.

Another option would be to use OutputTo, and use the PDF format to output
the report to a file, then send it as an attachment using Outlook
automation.

Dale

Now I send my report with following code

SubjectBox = "Aanpassen database SALES met nieuwe input voor klanten van "
& Forms!Hoofdmenu!Tekst24
MessageBox = ""
DoCmd.SendObject acSendReport, "Fiche", acFormatHTML, ontvanger, , ,
[SubjectBox], [MessageBox], -1

But.... it doesn't look nice.
Changing acFormatHTML into acFormatTXT doesn't look much better...

It would be nice to send it as a doc or as a pdf file

Can this be done?

Thanks

 

[Jean-Paul]

I use access2003

What version of Access are you using? If A2007, then use acFormatPDF. I
think Steve Lebans has something on his website at:
http://www.lebans.com/reporttopdf.htm that might be useful if you don't have
2007.

Another option would be to use OutputTo, and use the PDF format to output
the report to a file, then send it as an attachment using Outlook
automation.

Dale

Now I send my report with following code

SubjectBox = "Aanpassen database SALES met nieuwe input voor klanten van "
& Forms!Hoofdmenu!Tekst24
MessageBox = ""
DoCmd.SendObject acSendReport, "Fiche", acFormatHTML, ontvanger, , ,
[SubjectBox], [MessageBox], -1

But.... it doesn't look nice.
Changing acFormatHTML into acFormatTXT doesn't look much better...

It would be nice to send it as a doc or as a pdf file

Can this be done?

Thanks

 

[Jean-Paul]

I don't see a acFormatPDF option...

could you please explain the OutputTo option a bit more please?
Thanks
JP

What version of Access are you using? If A2007, then use
acFormatPDF. I think Steve Lebans has something on his website at:
http://www.lebans.com/reporttopdf.htm that might be useful if you
don't have 2007.

Another option would be to use OutputTo, and use the PDF format to
output the report to a file, then send it as an attachment using
Outlook automation.

Dale

Now I send my report with following code

SubjectBox = "Aanpassen database SALES met nieuwe input voor klanten
van " & Forms!Hoofdmenu!Tekst24
MessageBox = ""
DoCmd.SendObject acSendReport, "Fiche", acFormatHTML, ontvanger, , ,
[SubjectBox], [MessageBox], -1

But.... it doesn't look nice.
Changing acFormatHTML into acFormatTXT doesn't look much better...

It would be nice to send it as a doc or as a pdf file

Can this be done?

Thanks