actioned failed message

[Guest]

I have a macro attched to a command button. It opens up an eMail which a
person can either send or decde not to send. If the user 'x's out if he does
not want to send the eMail, they get the Microsoft ACTION FAILED message with
"HALT" button.
I do not want them to get this message. Is there a way to get around it?

 

[Steve Schapel]

Easiest solution is to teach the user not to click the command button
unless they intend to send the email.

What are the actions in your macro? Where is it that the user is
'x'-ing out?

 

[Guest]

Users have to use the button. It opens up eMail among other things. The
actions in the macro are : sendobject ....To: 'eMail addresses'
subject : ="Please Approve Request Number " & [Forms]![frm Add]![ReqNum] & "
for " & [Forms]![frm Add]![NetAm]

the eMail pops up for edit with all the information. No problem here.

The user can send the eMail without any problem. BUT if the user decides not
to send, he/she can 'X' out closing the email. The X is the Email X. This is
where the Halt message appears.

 

[Steve Schapel]

Mn,

Ok, thanks for the further explanation. I have not been able to
replicate this behaviour. Which version of Access are you using? And
which Email client? Is the Edit Message argument of the SendObject
action in your macro set to Yes?

 

[Guest]

outlook 98
access 97
Edit Message action is set as YES,because the user can add more information
on the body of the invoice or may choose not to send th email at All (this
is wher the problem arises)
Is this message considered as Access Error message? It is a Macro message
(...HALT..Macro??)
If so, if I put 'resume next' in on-error , will it do the trick?
thank you

Mn,

Ok, thanks for the further explanation. I have not been able to
replicate this behaviour. Which version of Access are you using? And
which Email client? Is the Edit Message argument of the SendObject
action in your macro set to Yes?

--
Steve Schapel, Microsoft Access MVP

Users have to use the button. It opens up eMail among other things. The
actions in the macro are : sendobject ....To: 'eMail addresses'
subject : ="Please Approve Request Number " & [Forms]![frm Add]![ReqNum] & "
for " & [Forms]![frm Add]![NetAm]

the eMail pops up for edit with all the information. No problem here.

The user can send the eMail without any problem. BUT if the user decides not
to send, he/she can 'X' out closing the email. The X is the Email X. This is
where the Halt message appears.

 

[Steve Schapel]

I am sorry, Mn, I have tested this with Access 97, Access 2000, Access
2002, and Access 2003, and I do not get the same thing happening. I am
not in a position to test with Outlook 98, but then the Outlook version
should not be implicated anyway. I can't understand why this is
happening. There are no other actions in the macro, right? And you are
not including a report or some such on the email, right? Anyway, there
is no way you can stop it... you will have to use a VBA procedure
instead of the macro.

 

[Guest]

Thank you. I will try VBA procedure.

I am sorry, Mn, I have tested this with Access 97, Access 2000, Access
2002, and Access 2003, and I do not get the same thing happening. I am
not in a position to test with Outlook 98, but then the Outlook version
should not be implicated anyway. I can't understand why this is
happening. There are no other actions in the macro, right? And you are
not including a report or some such on the email, right? Anyway, there
is no way you can stop it... you will have to use a VBA procedure
instead of the macro.