SendObject falis and stops macro

[Big Bob]

I have 2 macros that send emails, one has an RTF file attached and the ohter
simply has text in the 'message' box. When I run them I get the following
error when it attempts to execute the SendObject command:

Arguments: -1,,,,,,Course Evaluation,Click on the link below.,Yes

Error Number 2950

When I click the 'Stop All Macros' button I get: 'The command or action '|'
isn't available now.'

This happens in both macros. I have made the folders where the databases
are stored 'trusted' locations and changed the security settin to allow all
macros to run. The database was converted from 2003 where it all ran
smoothly. I have also tried re-creating the macros in 2007 but get the same
error.

All help much appreciated.

Bob

 

[Steve Schapel]

Bob,

What is the meaning of the "-1" in the first argument of the macro?

--
Steve Schapel, Microsoft Access MVP

I have 2 macros that send emails, one has an RTF file attached and the
ohter
simply has text in the 'message' box. When I run them I get the following
error when it attempts to execute the SendObject command:

Arguments: -1,,,,,,Course Evaluation,Click on the link below.,Yes

Error Number 2950

When I click the 'Stop All Macros' button I get: 'The command or action
'|'
isn't available now.'

This happens in both macros. I have made the folders where the databases
are stored 'trusted' locations and changed the security settin to allow
all
macros to run. The database was converted from 2003 where it all ran
smoothly. I have also tried re-creating the macros in 2007 but get the
same
error.

All help much appreciated.

__________ Information from ESET Smart Security, version of virus signature database 4142 (20090609) __________

The message was checked by ESET Smart Security.

http://www.eset.com