Limit pages to be e-mailed

[ballbearing]

Hello again!

Simple question:

Using code such as

stDocName = "DetailedSummary"
DoCmd.SendObject acReport, stDocName, acFormatHTML, Form_OutstandingBalance.Email, , , "Service Statement"

This particular report creates 2 pages but I only want to send the first page. How can I limit the email to just the 1st page?

Gawd I love this Access stuff..too bad I don't know what I'm doing.

 

[lupins46]

There isn't any simple way to do what you ask.

You should modify the report so that it creates the output that you want to email.

An alternative is to export the current report to a .rtf file and edit it in Word, either manually or in code and then email the modified file.