Send Object command

[Casey Matthews]

I am having problems with the send object command. I had
this working prior to an IT update that was done, and now,
when I try to send object (a particular report) it says
that it's unable to do this.

I have it set up as follows: There is a button on the
bottom of a form that, when clicked, runs a macro that
generates a report based off the currently loaded form,
then opens outlook, and has the report as an .rtf
attachment, waiting for the user to enter the recipient
and click send.

Now I'm getting an error message.
IT wasn't sure what to do to fix it, and none of them are
ACCESS guru's.
Any ideas?

 

[Cheryl Fischer]

Casey,

Just saying: "I'm getting an error message." does not give anyone who
might want to look into this problem much to go on.

Please post the exact error message, list your macro actions and their
properties and let us know the macro action which appears to be failing.

 

[Guest]

Thanks for the response.

Here is the info you requested:

The macro is set up as follows:

OpenReport - Set to open report named NEW LARGE LOSS
REPORT in a print preview view with no filter. Although,
the query that the report is based on has a filter of
sorts. Under Occurence number, is a [Enter Claim Number]
criteria.

SendObject - set to send the above referenced report.
Close - Set to close the above referenced report.

The error message I'm getting is:
Macro Name: (the name of my macro)
Condition: True
Action: Send Object
"3, NEW LARGE LOSS REPORT, RichTextFormat (*.rtf),,,,New
Large Loss Report, Attached is a new Large Loss Report,No,"

That's as much as can be read. The only button that can be
clicked is "HALT", none of the others are available, and
the error box cannot be expanded to read the entirety of
the error message.

Also, I have not changed anything in the macro, and this
used to work. Some update was recently done to our PC's,
and the macro no longer works. I think it's got something
to do with the way in which Access and Outlook are
communicating.

 

[Cheryl Fischer]

I would delete the Open Report action from the macro (as well as the Close
Report action). In testing, with a report that has as its recordsource a
parameter query, the SendObject action alone opened the report. The
parameter query requested my input, as expected, and the email was sent with
the report as an RTF.


--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

Thanks for the response.

Here is the info you requested:

The macro is set up as follows:

OpenReport - Set to open report named NEW LARGE LOSS
REPORT in a print preview view with no filter. Although,
the query that the report is based on has a filter of
sorts. Under Occurence number, is a [Enter Claim Number]
criteria.

SendObject - set to send the above referenced report.
Close - Set to close the above referenced report.

The error message I'm getting is:
Macro Name: (the name of my macro)
Condition: True
Action: Send Object
"3, NEW LARGE LOSS REPORT, RichTextFormat (*.rtf),,,,New
Large Loss Report, Attached is a new Large Loss Report,No,"

That's as much as can be read. The only button that can be
clicked is "HALT", none of the others are available, and
the error box cannot be expanded to read the entirety of
the error message.

Also, I have not changed anything in the macro, and this
used to work. Some update was recently done to our PC's,
and the macro no longer works. I think it's got something
to do with the way in which Access and Outlook are
communicating.

-----Original Message-----
Casey,

Just saying: "I'm getting an error message." does not give anyone who
might want to look into this problem much to go on.

Please post the exact error message, list your macro actions and their
properties and let us know the macro action which appears to be failing.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX





.