Out of Memory Error

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

Guest

I'm trying to email a report using the on click event for a button in a
switchboard form and it worked great once, but I am now getting a 'Out of
Memory error' every time.

I'm using Access 2000. Here's my code for the button's on click event:

Private Sub Command1_Click()
On Error GoTo Err_Command1_Click

Dim stDocName As String
Dim stLinkCriteria As String

DoCmd.Close

stDocName = "RptBillingListSend"
DoCmd.SendObject acSendReport, stDocName, "snapshot format",
"(e-mail address removed);[email protected];[email protected];[email protected];[email protected];[email protected];[email protected]", , , "Billing List " & Now()

DoCmd.OpenForm "FrmBillingUpdate", , , stLinkCriteria

Exit_Command1_Click:
Exit Sub

Obviously, I've changed the Email accounts - they are all valid and correct.
I had the same result on multiple workstations with no other applications
open, so I don't think it actually is a Memory issue. I can't figure out why
it worked one time, but won't work again...

Any idea on what's causing this and how to fix it? Is there a limit on the
# of email accounts you can send a report to (I could break it down into two
sends)?

Thanks in advance for any help!

Parker
 
Can you try setting "Snapshot Format" to acFormatSNP.

And can you also check whether the error actually happens when sending the
report or opening the form.
 
Back
Top