Closing a report after emailing.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2002 to produce invoices which are emailed to clients.
When I have completed the data entry using an Input form I press a button on
the form, which calls up a VBA Event, which starts with :

DoCmd.OpenReport stDocName, acViewPreview

This opens the invoice in report format ready for emailing. I then use:

DoCmd.SendObject acSendDataAccessPage, stDocName, acFormatRTF, stTo, , ,
"Invoice No. " & stInvoice, strMsgBody

This attaches the report as an RTF file to the email with the desired
message, which I can then send. When I press the send button the email
closes and I return to the Access view of the report which I then have to
close manually.

What I would like to do is after sending the email, to have the report
automatically close so I return to the input screen ready to send the next
emailed invoice. I am sure it is simple but I cannot seem to get it to work.

Any help appreciated.
 
Back
Top