"Object Required" when opening an email from Form Button

[Allan]

Hi

From examples in this forum, I have used the following code several times under a command button:

Email.HyperlinkAddress = "mailto:" + EmailWork

to successfully open an email in Outlook ready to complete the other fields (Subject and Body etc).

I used the same code in a new database (still Access 2007) and get a message "Object required". The only difference between the two databases is that the button on the second database is on a subform under one of four Tabs.

Can anyone assist with an explanation regarding the meaning of Object required and do I need to identify the subform in the coding?

TIA

 

[GinaWhipp]

I would check your References ( http://www.regina-whipp.com/index_files/References.htm ) and make they match the References in a database where it does work.

 

[Allan]

Thanks Gina,

I had already checked the references and they were the same. I did not have the time to spend on working it out so had to take that particular function out of the database.
I also checked the obsolete References on your link and did not have any of those checked. I have a little time to spend on trying to work it out now -
so back to square one. Thanks anyway.

 

[GinaWhipp]

Hard to tell by your reply... are redoing or do you want more suggestions?