Access 2003 SendObject not available

[Jack M Peyton]

At work a database was created using Access 2000. Access was recently
upgraded to Access 2003. Now when we try to E-Mail a report we get the a
"SendObject not available" message. Are there any fixes for this?
Your help will be appreciated.
Jack Peyton

 

[Daniel Pineault]

Your code might help.

That said, I did a simple Google search and came across the following that
might be worth a look at:

http://www.utteraccess.com/forums/printthread.php?Cat=&Board=84&main=1038480&type=thread

Also, Recently I have run into various problem simply because of PC not be
up-to-date. The computer in question, have you installed all the SP to
windows and Office?
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Jack M Peyton]

Bonnie,
The code is:

DoCmd.SendObject acReport, "RWkOrd", "SnapshotFormat(*.snp)", _
Forms!FWkOrd!EMailAddressID.Column(1), "",
Forms!FWkOrd!BOCEmpNo.Column(7), _
"CalTrans Service Request " & Forms!FWkOrd!WONum, _
Eval("""Attached is CalTrans Service Request Number "" &
[Forms]![FWkOrd]![WONum] & "" for ""&[Forms]![FWkOrd]![BildID].Column(2)&"".
If any additional information is needed please contact "" &
[Forms]![FWkOrd]![BOCEmpNo].[Column](4) & "" at "" &
Format([Forms]![FWkOrd]![BOCEmpNo].[Column](2),'(000) 000-0000')") & ".",
True, ""

The code has worked for several years in Access 2000.
Jack Peyton