SendObject

  • Thread starter Thread starter Gareth
  • Start date Start date
G

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
 
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
 
SendObject works fine when frmTwo is open on its own but
when frmOne is open 'underneath' it doesn't.

Any ideas?
 
Back
Top