Out of Memory Error

[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

 

[Guest]

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.