sending report looks awfull

  • Thread starter Thread starter Jean-Paul
  • Start date Start date
J

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
 
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
 
could you please explain the OutputTo option a bit more please?
Thanks
JP

Dale said:
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 said:
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
Click to expand...
Click to expand...
 
I use access2003

Dale said:
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 said:
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
Click to expand...
Click to expand...
 
I don't see a acFormatPDF option...

Jean-Paul said:
could you please explain the OutputTo option a bit more please?
Thanks
JP

Dale said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top