Error 2046

[Swannie]

Has anyone encountered this before ?

What I am trying to do is use acSendQuery to Outlook and receive the following error message.

"The command or action 'OutputTo' isn't available now.

You may be in a read only database or an unconverted database from a previous version.

The Type of object the action applies to isn't currently selected or isn't in the active view.

Use only those commands and macro actions that are currently available for this database."

The code that this is based on is

DoCmd.SendObject acSendQuery, "qryX2", acFormatXLS, strCoordMail, , , "Report for " & Me.cboBrand.Column(1), "" & vbCrLf & "", False

Everyone should be using access 97.

Thanks

 

[Mile-O]

Why are you sending a line break?

"" & vbCrLf & ""

 

[Swannie]

Because I took the crap messages out for posting on the forum

 

[Surjer]

Should it not be

DoCmd.SendObject acQuery, "qryX2", acFormatXLS, strCoordMail, , , "Report for " & Me.cboBrand.Column(1), "" & vbCrLf & "", False

 

[Mile-O]

Good spot!