Error when Using the SendTo object

[Guest]

When I run a report from Access 2000 sr-3. Then I try to use File, Send To,
Mail recepient as an attachment. Then I select Microsoft Excel, I get the
following message
Microsoft Access
Object variable or with block Variable not set.

This just started today. I tried to do the same thing on two different
computers and the results were the same.

Can someone shed some light as to what is going on?

 

[Guest]

Try re-registering the Accwiz.dll, Msado15.dll and DAO360.dll files.
Click on Start > Run. Then enter the commands:

Regsvr32 Accwiz.dll
Regsvr32.exe "C:\Program Files\Common Files\system\ado\Msado15.dll"
Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________