Formating Report via SendObject - HTML Format Breaks into pieces

J

Jasmine

When using the Sendobject command with the following parameters I noticed
that the reports gets broken in many HTML pieces.
Is there a way to send the report to say a PDF file or other formats where I
can see all the pages like a regular report should look.

This is the command that's being used.

Docmd.sendobject acsendreport, "pending report", acFormatHTML,
(e-mail address removed), (e-mail address removed),-
, ,"pending reports","Pending Report Illustrator",False
 
A

andrewg

When using the Sendobject command with the following parameters I noticed
that the reports gets broken in many HTML pieces.
Is there a way to send the report to say a PDF file or other formats where I
can see all the pages like a regular report should look.

This is the command that's being used.

Docmd.sendobject acsendreport, "pending report", acFormatHTML,
(e-mail address removed), (e-mail address removed),-
, ,"pending reports","Pending Report Illustrator",False

You should be able to install an acrobat print driver and send the
report to the print driver to generate a PDF file....
 
G

Guest

Snapshot is the best format.
But user has to have the snapshot viewer installed.
Snapshot viewer comes with office, or download from MS
 
T

Tony Toews [MVP]

Jasmine said:
When using the Sendobject command with the following parameters I noticed
that the reports gets broken in many HTML pieces.
Is there a way to send the report to say a PDF file or other formats where I
can see all the pages like a regular report should look.

Not using SendObject. SendObject's twenty limitations
http://www.granite.ab.ca/access/email/sendobject.htm

You will need to use a different method. Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Creating PDF files from within Microsoft Access
http://www.granite.ab.ca/access/pdffiles.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top