Access 2007 Runtime and SendObject

[Mike Z.]

I have an Access 2007 database that I'm trying to distribute using Access
2007 Runtime and I would like to have an option for a user to send their
order in via e-mail. I've tried the SendObject only to receive a runtime
error and then the program closes. I've downloaded and installed the PDF
add-in for Office 2007 and that works fine. Can anyone help me accomplish
this?

Thanks

 

[Tony Toews [MVP]]

I have an Access 2007 database that I'm trying to distribute using Access
2007 Runtime and I would like to have an option for a user to send their
order in via e-mail. I've tried the SendObject only to receive a runtime
error and then the program closes. I've downloaded and installed the PDF
add-in for Office 2007 and that works fine. Can anyone help me accomplish
this?

Do you have error handling in your code?

On error goto tagError at the top

at the bottom

exit sub

tagError:
msgbox err.description

If not put the error handling there and in all your VBA code by using
the button inside MZTools.

Then tell us the exact error message.

Tony

 

[Mike Z.]

I put the error handling in, ran the program, and it worked fine (no runtime
error). The only thing I can think is that I was using a database that was
create in Access 2000 format and Access 2007 Runtime. While I was waiting
for a response, I converted the database to an Access 2007 format but never
tried the e-mail option until now. So I think by converting to the Access
2007 format that may have fixed my problem.

Thanks for response!!!