MS Access 2000 Sendobject Method

[kvrsudheer]

Hi all
I have been breaking my head to get around the option of activating a mail client to send emails from Access. I have 1 table which holds all the transactions and another table which has the email address for the various accounts in the transactions.The aim is to send a report for each of the accounts.The sendobject is working in a Do .. Loop. Everytime the application stops with a run time error 10 ( This array is fixed or temporarily locked). Infact I am referring to each of the mail address by the field name rather than the location emailid("Mail ID") rather than emailid.fields(0).
It works perfectly on Access97 and occassionally on 2000.
Pleeeeeeeeeeease I am dying for assistance on this subject.
Many thnx in Advance
Sudheer

 

[Buja]

Did you ever get this resolved?

I've got a similar issue using SendObject to email a report in Rich Text format. It worked great in Access 97 but NOT in Access 2002. The only unique thing about this report is that it uses the DecimalPlaces property to change display format depending on a condition. SendObject does NOT work but there is NO error message.

Does this sound familiar to you?