FYI - in case it happens to someone else...
I got around (but never figured out) the multiple pages issue by previewing the page and issuing a PrintOut command to print just page 1. Works pretty good even if it briefly flashes the report on the screen before it goes away.
I used the following in the procedure associated with the button the fires off the report:
DoCmd.OpenReport "rptFormalEmail", acPreview :Preview makes it an active window
DoCmd.PrintOut acPages, 1, 1 :Prints active window - 1st page only
DoCmd.Close acReport, "rptFormalEmail", acSaveNo :Close the report and don't prompt to save
-Todd C.
[Non-text portions of this message have been removed]
I got around (but never figured out) the multiple pages issue by previewing the page and issuing a PrintOut command to print just page 1. Works pretty good even if it briefly flashes the report on the screen before it goes away.
I used the following in the procedure associated with the button the fires off the report:
DoCmd.OpenReport "rptFormalEmail", acPreview :Preview makes it an active window
DoCmd.PrintOut acPages, 1, 1 :Prints active window - 1st page only
DoCmd.Close acReport, "rptFormalEmail", acSaveNo :Close the report and don't prompt to save
-Todd C.
[Non-text portions of this message have been removed]