SendObject

[Gareth]

I want to automate the sending of a report in an e-mail.
The report is based on a query and I am having the
following problem:

I have frmOne open and if the user chooses 'No' from a
certain combo box then frmTwo appears. The user then
completes the second form and clicks on the E-mail button
which sends the message to the desired receipients.

The only problem is that there is no data in the report
when it is opened, I think it is something to do with the
fact that there are two forms open at the same time but
cannot find a way around it.

Can anyone please help?

Gareth

 

[Justin Mills]

From my understanding you can't sent a report via email.

You wound prolly need to convert the report to something
like a PDF, for the reciptant to read it. You could
possibly look at www.daneprairie.com, they have a PDF
driver, that acts like a printer. ie print the report to
the PDF printer, then send the PDF file to the recipant

Hope this helps you in some way.

Justin

 

[Gareth]

SendObject works fine when frmTwo is open on its own but
when frmOne is open 'underneath' it doesn't.

Any ideas?